FbDataAdapter truncates alias names to 31 characters when using embedded server

[zur003]

With Firebird 4, the default object length was raised from 31 bytes to 63 characters, so column names can now exceed the old 31 byte limit. However, it appears that if FbDataAdapter is used to import the results of a query into a .Net DataTable, the column names are being truncated to 31 bytes.

[zur003]

Apologies for my misunderstanding. I was using a SELECT query with aliases for the column names, and some of those aliases exceeded 31 characters in length. These were being truncated to 31 characters, but the problem is not in FbDataAdapter but rather in Firebird itself. I shall raise this as in issue on a more appropriate site.

[zur003]

After a bit more experimentation, I am re-opening this Issue. The problem I was seeing - truncation of column aliases to 31 characters - is occurring only with the embedded server, not when using a "network" server. Queries issued using the isql application do not have this problem, whether the server is embedded or not.

Is there a chance this might be fixed as part of #1023?

[gilsonjoanelo]

Is this validation necessary? I'm looking at the SQL Server code and so far I haven't seen any checks on the Entity Framework Core side.

[cincuranet]

Can you provide repro?

[gilsonjoanelo]

Yes, can I send you a script in a console? Gilson Joanelo Programador, .net Framework, .Net Core, Angular TS, C#, Android, iOS, Swift, Kotlin, Java, Php, Análise de sistemas, Web Developer Em qua., 20 de mar. de 2024 às 06:58, Jiri Cincura ↹ < ***@***.***> escreveu:

…

Can you provide repro? — Reply to this email directly, view it on GitHub <#1123 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACDBAUIJITMJ2FNBGOFVORLYZFMVFAVCNFSM6AAAAAA2WRLJQWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMBZGE3DSOJZGI> . You are receiving this because you commented.Message ID: ***@***.***>

[cincuranet]

Yes, can I send you a script in a console?

Does not make sense to me. I need code that uses FirebirdClient to repro it.

[gilsonjoanelo]

ok, I'll reproduce the problem you say in the issue, I'll send you the entire process, with the code. Gilson Joanelo Programador, .net Framework, .Net Core, Angular TS, C#, Android, iOS, Swift, Kotlin, Java, Php, Análise de sistemas, Web Developer Em qua., 20 de mar. de 2024 às 07:06, Jiri Cincura ↹ < ***@***.***> escreveu:

…

Yes, can I send you a script in a console? Does not make sense to me. I need code that uses FirebirdClient to repro it. — Reply to this email directly, view it on GitHub <#1123 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACDBAUNXROY54W7PQTXRJU3YZFNTNAVCNFSM6AAAAAA2WRLJQWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMBZGE4DKNZRHA> . You are receiving this because you commented.Message ID: ***@***.***>