FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
152 stars 62 forks source link

[Firebird 2.5] [FirebirdClient 9.1.1] Problem with accented letters in charset NONE #1130

Closed rkiguti closed 10 months ago

rkiguti commented 10 months ago

I am using .NET 6, with a Firebird 2.5 and the last version of FirebirdClient 9.1.1 and the accented letters are returning always with "?".

My connection string: User=SYSDBA;Password=masterkey;Database=ERP.FDB;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;

I already tried change the chatset to utf8 and it continues returning ? in order the accented letter.

I found an old issue with the same problem. But it was an older version from client.

And when I use another tool like Ibexpert with charset NONE it works.

rkiguti commented 10 months ago

I solved the problem. I installed a nuget package to add Windows-1252 encoding in my application.

The .NET Core dont know Windows-1252 as default.

Install-Package System.Text.Encoding.CodePages

And then register when starts my application:

Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);