Devart Forums

I just installed the latest version 2.10.7 and I cannot read UNICODE from my database anymore. (Database version 8.0.3 on Windows)

It seems that I can write Unicode characters to the database. When I look at the data in pgAdmin it looks ok. However, the data that is returned to my application is scrambled.

As soon as I remove the new version and install the old version 2.10.3 everything works as expected.

Regards,

Joern


P.S.: Sorry, I do not have the versions between 2.10.3 and 2.10.7 - therefore I cannot tell exactly which version broke the code. If you have a download link for the older versions I will try them.

Please specify a code sample to open connection and Encoding option at the server.
Have you set PgSqlConnection.Charset property after PgSqlConnection.Unicode?

I do not set Charset property. I set Unicode=true. (I tried setting Unicode in the connection string and in code but without a difference.)

I have the following encoding options for the database:

PostgreSQL (8.0.3) general:

Locale = German, Germany
Encoding = LATIN1

Database option (when creating database)

Encoding = UNICODE

As I wrote before: As soon as I deinstall the new version and install an old version (2.10.4) everything is correct. (With the same database and encoding options of course.)

Regards,

Joern

We reproduced problem and fixed it. This fix will be included in the next PostgreSQLDirect .NET build.