Page 1 of 1
[patch_done] ZROQuery show czech characters OK, ZQuery don't
Posted: 20.03.2012, 14:04
by 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 ...
Posted: 20.03.2012, 21:41
by 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
Posted: 21.03.2012, 11:20
by 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
Posted: 21.03.2012, 16:09
by 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..