[patch_done] ZeosLib on Delphi XE charset

[MikeSP2]

Hello,

i installed ZEOSLib(SVN checkout rev. 933) in Delphi 2010 and XE on the same computer. In Delphi 2010 it works great with mysql. In Delphi XE i get wrong chars if i use some german spezial chars like ö,ü,ä,Ä,Ü,Ö.

The tables of my mysql database use the charset latin1.

I moved my big project from Delphi 2010 to Delphi XE with the same ZEOS componets. In Delphi 2010 it works very well but now i get big troubeles with spezial chars.

Is there some differenz between 2010 and xe? Both used unicode ?

I thested some settings in ZConnect like charset=utf8 but it wont work.
Are there some errors in ZeosLib for XE?

Regards
Mike

[mdaems]

This might be caused by wrong {$IFDEF} code in zeoslib as well. But it's strange nobody mentioned it before.

Mark

[MikeSP2]

Do you mean {$IFDEF} in ZEOS.inc or somwere else ?

regards
Mike

[seawolf]

I checked on the entire library and there's only an ifdef located in ZAbstractRODataset.pas which could cause this strange behaviour.

[MikeSP2]

Next round...

I installed RAD Studio XE new. I installed ZEOS 7 Rev 933 new.
No old things on this computer.

Same result

Is there somthing with a german Windows XP or german Rad Studio?
Now i put a zsql-monitor component on my form.
In this txt file all my spezial char are allright. If i take alook in my database
i see only terrible stuff.

All these characters Ö,Ü,Ä,ö,ä,ü insert with Navicat in the database are displayed right if i read it with zeoslib.

I think its only to write these caracters with zeoslib into the database.
Is there somethig else to test??

Regaeds
Mike

[ism]

try from
http://sourceforge.net/scm/?type=svn&group_id=35994

svn co https://zeoslib.svn.sourceforge.net/svnroot/zeoslib zeoslib

maybe select in Navicat properly client charset

[Lilive]

Hello,
you should read this post : http://zeos.firmos.at/viewtopic.php?t=3124
We encountered the same problem with Zeos 7 + Delphi XE + MySQL and French literature " é è ê ë ô ..."
The solution given is valid and solves these problems.
Good day.

[MikeSP2]

Hey Lilive,

this fix my problems. Thank You!

I put codepage=utf8 in my connection and it works.

But why is this code not in the official release??

is there any reason agaist this patch.

Regards

Mike

[Lilive]

But why is this code not in the official release??
is there any reason agaist this patch.

Hi Mike
Only one member of the dev team Zeos can answer this question !
Zeoslib 7 is still under development.
Maybe this patch causes problems with other DBMS ...
good weekend
Lilive

[EgonHugeist]

use http://zeos.firmos.at/viewtopic.php?t=3427