[patch_done] ZROQuery show czech characters OK, ZQuery don't

[thcom]

hi, in my app differs output from ZReadOnlyQuery and ZQuery, i use Delphi XE and i try zeoslib 667, v7 v8 v9 and today new branch from EgonHugeist (thanks for your great work !) i try to uncomment WITH_CLIENT_CODE_PAGE_OPTIONS, i try to study http://zeos.firmos.at/viewtopic.php?t=3427
but nothing helps i attach a example app with 2 grids, one is based on zreadonlyquery, second on zquery, i use mysql 5.1, dump of test DB is attached, you should change hostname, user and pass ...

thanks for your help ...

[EgonHugeist]

I'll check what goes wrong here..

On the first look you're XE-user:

Set the TZConnection.CLientCodePage to UTF8 OR to WIN1250 (exists in MySQL?) (in your Property-Editor)..
or TZConnection.Properties.Text := codepage=utf8;

you do not need to SET NAMES UTF8;

This should solve your problems..
It's my fault because of the missing detailed Roadmap (is in work but i'm out of time actually)

can you confirm this?

best regards

EgonHugeist

[thcom]

thanks, i depply test it, and conclusion is
i dont need SET NAMES
when i use ClientCodePageOptions = cp1250 ZQuery shows bad characters
whe i use ClientCodePageOptions = utf8 ALL is WORKING fine

for other rededers, don't forget set coSetCodePageToConnection to true

so thank you

[EgonHugeist]

OK, i'll checkup whats wrong here with cp1250 (east european)..

Btw. please update your revision. The ClientCodePageOptions i've removed last week.
I don't want to make everything more complicated as it must be. So the thread is updated too.

can you please test the Ansi-support again?

best regards..