Zeos 7 + Mysql + Lazarus
Posted: 27.09.2010, 13:56
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?
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?