Delphi2009, Zeos 7, SQLite and unicode problem (again)

[Dr Mac]

I know, there are lots of topics about unicode problems, but I didn't find any solution.
My system is Windows XP, Delphi2009 and Zeos 7 (671).

I dropped a ZConnection. a ZTable, a Datasource and a DBGrid on a form. Connected the components together properly and the grid indicated the table data, what I want. But unicode strings displayed wrong. For example:
original string displayed string
Demjén Demj‚n
Hungária Hung ria
etc.

Is there any solution?

[php4pro]

i have same problem with Delphi 2007 with ZEOSLib 6.6.5 any solution ?

[seawolf]

Hi, zeos 6.6.5 does not support unicode.
Apart this, a "simple" solution is specify on ZConnection.Properties which codepage you are using

[php4pro]

i put this on my code

Code: Select all

con1.Properties.Add ('Codepage=UTF8');

but still it's not working

There is one solution i found it it's using UTF8Decode and the data came on dbgrid fine.

Does this mean Zeos support UTF but dbgrid not supporting UTF ?

Still not clear !

Best regards