search

FirebirdSQL / NETProvider

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

Unicode problems #1103

Closed gilsonjoanelo closed 1 year ago

gilsonjoanelo commented 1 year ago

Hi, I'm using Google Translate

I have a problem turning off Unicode in Firebird connected EF Core Net 6.0. Currently there is an option in which it is possible to define the String property, this is OK. Even a PR suggested by me was incorporated into the project.

However, when entering the FbStringTypeMapping class, the unicode parameter is always true. This makes the code behave like Unicode, however our code is not unicode.

Is there any way to globally turn this off in Firebird Provider for Net Core?

cincuranet commented 1 year ago

Do you have a code to show the behavior?

gilsonjoanelo commented 1 year ago

I am attaching two files, one with the code and one with the log

202304261426.log

Artigo.cs.txt

Even with the definition of the property IsUnicode(false), it is always considering Unicode(true). which causes the problem that appears in the log, all the queries are transformed into the wrong Charset. the Database Charset is Win1252. We do not use Unicode in this database. I don't know if there is any way to force FbOptions to respect Unicode(false)

cincuranet commented 1 year ago

You can play with this. But it will get you only so far. There's few places in EF Core provider with UTF-8 encoding assumption and at the moment I don't have plans to have support for charsets other than UTF-8, mainly because of resource/cost.