Page 1 of 1

Zeos 7 + Mysql + Lazarus

Posted: 27.09.2010, 13:56
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?

Posted: 02.10.2010, 20:56
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

Posted: 02.10.2010, 22:55
by ism
table character set was utf8

lazarus for win 32