Bug in 7.14.1470 ?

[ole.tetzschner]

Hi

After upgrading from 7.13.1437 to 7.14.1470, I can no longer update table-rows. I'm constantly getting the following Exception:

Code: Select all

invalid byte sequence for encoding "UTF8": 0x00

I've check with dbMonitor and both SQL-syntax and parameters looks fine.

My connectionString:

Code: Select all

connectionString="User Id=...;Password=...;Host=...;Database=...;Unicode=True;Persist Security Info=True;Schema=public"

I can read the rows without problem, but when I update, the above exception is thrown. I've always upgraded to the latest version, but never seen this before. Any clues would be appreciated.

With kind regards, Ole

[Shalex]

We cannot reproduce the error.

1. Please send us a small test project for reproducing.
2. Also, provide the DDL/DML script for running your project.
3. Tell us the version of your PostgreSQL Server and encoding used in your database.

[belidzs]

Same happened to me, I had to revert back to 7.13.1366.

[belidzs]

I can confirm that the latest working version is 7.13.1437

[ole.tetzschner]

Devart has reproduced this error. We are now waiting for a fix / update.

[Shalex]

The bug with updating TEXT columns in UTF8 databases is fixed: viewtopic.php?f=3&t=39477.