Page 1 of 1

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

Posted: 12.07.2009, 18:19
by 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?

Posted: 27.07.2009, 12:47
by php4pro
i have same problem with Delphi 2007 with ZEOSLib 6.6.5 any solution ?

Posted: 27.07.2009, 20:27
by 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

Posted: 27.07.2009, 21:56
by 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