Another UTF8 problem (with SQLite this time)

jeremicm · Post by **jeremicm** » 02.11.2011, 10:29

In my tries to find solution to previous utf problem, i came around another one... I have SQLite3 table with 4 text fields. When i try to enter "зщшгн РОЛДЖ" (random russian characters) in it, in database, i see all characters, but in grid or any components that show data from table, i see only lot's of ????? characters (question marks)...

When i try with east europe latin characters (ždšćč ŽÐŠĆČ) i see ŽÐŠCC ždšcc, and again, in database everything is ok...

any ideas or solutions for this?

thanks in advance
Martin

Wild_Pointer · Post by **Wild_Pointer** » 02.11.2011, 17:31

Hello jeremicm,

I guess you are not using unicode components. Please try TNT components or similar (or have delphi XE + that supports unicode out of the box).

Good luck!

jeremicm · Post by **jeremicm** » 02.11.2011, 21:17

i already use xe2 with upd1 and latest zeos svn...

Wild_Pointer · Post by **Wild_Pointer** » 03.11.2011, 07:19

have you set codepage=utf8 in properties of tzconnection ?

[update]
by writing "latest zeos" you meen 6.6.6 (stable) or 7.0 (beta)?

jeremicm · Post by **jeremicm** » 03.11.2011, 08:20

codepage=utf8 is set, and i'm using 7.0 zeos from svn...

Wild_Pointer · Post by **Wild_Pointer** » 03.11.2011, 08:27

Hello, jeremicm,

I'm going to try XE2 these days, so I'll look into your problem too. Right now I have no ideas what else could be wrong.

mrLion · Post by **mrLion** » 29.11.2011, 15:57

jeremicm, in windows server use codepage=win1251. also if you DB use UTF8! threefore stil problem with russian codepage: write with use params SQL store in DB ????.

Post by **EgonHugeist** » 10.03.2012, 13:48

jeremicm,

I've detected some mistakes on the String-casts. I think i've solved this all in my private branch \testing-egonhugeist..

the "how to" you'll find here http://zeos.firmos.at/viewtopic.php?t=3427

please read carefully...

best regards