Page 1 of 1
Another UTF8 problem (with SQLite this time)
Posted: 02.11.2011, 10:29
by jeremicm
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
Posted: 02.11.2011, 17:31
by Wild_Pointer
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!
Posted: 02.11.2011, 21:17
by jeremicm
i already use xe2 with upd1 and latest zeos svn...
Posted: 03.11.2011, 07:19
by Wild_Pointer
have you set codepage=utf8 in properties of tzconnection ?
[update]
by writing "latest zeos" you meen 6.6.6 (stable) or 7.0 (beta)?
Posted: 03.11.2011, 08:20
by jeremicm
codepage=utf8 is set, and i'm using 7.0 zeos from svn...
Posted: 03.11.2011, 08:27
by Wild_Pointer
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.
Posted: 29.11.2011, 15:57
by mrLion
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 ????.
Posted: 10.03.2012, 13:48
by EgonHugeist
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