Zeos 7 + Mysql + Lazarus

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
blestan
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 13.02.2010, 12:17

Zeos 7 + Mysql + Lazarus

Post by blestan »

Hi All!
I Have a very odd problem with zeos+mysql+lazarus:
the table in contains correct cyrillic char data ( it's visible in phpmyadmin, sqlyog etc... even in lazarus db grid after

SQLQuery:=TZReadOnlyQuery.Create(Self);
with SQLQuery do
begin ;
Connection:=TDG_MySQL;
SQL.TEXT := 'SET CHARACTER SET `utf8`';
ExecSQL;
end;
SQLQuery.Free;

in the AfterConnect event of TZConnection )

everithing looks perfect till i try to modify a row ...
the text in the dbigrid is ok - displays the cyrillic chars
but after a post and a refresh this row goes to "????"
and it's ??? in all possible viewers like phpmyadmin and sqlyog...
it's seems like a weird double utf8encoding just before posting real data to db but i'm not sure....
any ideas where to look and patch zeos code?
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

Hello from Ukraine

I trying this

ZConnection1.properties = "codepage=cp1251"
ZConnection1.protocol=mysql-5

in 6.6.6 working ok with cyrillic
mysql version 5.1
Lazarus 1.0.8 fpc 2.6.0
ism
Zeos Test Team
Zeos Test Team
Posts: 202
Joined: 02.10.2010, 20:48

Post by ism »

table character set was utf8

lazarus for win 32
Lazarus 1.0.8 fpc 2.6.0
Locked