Open zur003 opened 11 months ago
zur003
commented
11 months ago 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
commented
11 months ago 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
commented
3 months ago 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
commented
3 months ago Can you provide repro?
gilsonjoanelo
commented
3 months ago 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 https://github.com/FirebirdSQL/NETProvider/issues/1123#issuecomment-2009169992, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACDBAUIJITMJ2FNBGOFVORLYZFMVFAVCNFSM6AAAAAA2WRLJQWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMBZGE3DSOJZGI . You are receiving this because you commented.Message ID: @.***>
cincuranet
commented
3 months ago 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
commented
3 months ago 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 https://github.com/FirebirdSQL/NETProvider/issues/1123#issuecomment-2009185718, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACDBAUNXROY54W7PQTXRJU3YZFNTNAVCNFSM6AAAAAA2WRLJQWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMBZGE4DKNZRHA . You are receiving this because you commented.Message ID: @.***>
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.