Zeoslib new version encoding problem, strange charaters

377 Views Asked by At

I have installed Zeoslib 7.2.4 because of updating to Delphi 10.2 and after testing my projects the result of SELECT isn't expected. The previous version 7.1.4 Works fine.

The results after updating to 7.2.4:

Worst results

Connection ClientCodePage is binary. If I change this to utf8 the results will look like this, The Address col is correct but Title is still corrupted:

Better result

The database and table collation is latin1_swedish_ci. I don't have a problem with version 7.1.4. One workaround for this problem is this:

TEncoding.Default.GetString(DBQuery.FieldByName('Title').AsBytes)

This is the expected result:

Expected result

0

There are 0 best solutions below