sqlite utf-8 strings

geran · Post by **geran** » 19.01.2007, 16:10

Hi,

please confirm that your Zeos library for sqlite 3 saves text correctly in database as utf-8.
I am asking this because I found to another forum that SQLAdmin from http://sqliteadmin.orbmu2k.de uses the Delphi ZeosLib which incorrectly stores strings encoded as the current ANSI code page instead of UTF-8.

The url is
http://sqlite.phxsoftware.com/forums/thread/1530.aspx

P.S.
I am developer who develops application both in Windows/WinCE/PocketPC. So, I am using your sqlite library for windows application and from phxsoftware for WinCE/PocketPC.

aducom · Post by **aducom** » 27.01.2007, 03:02

I cannot confirm that, you might want to convert before inserting?

geran · Post by **geran** » 29.01.2007, 14:52

Hi,

could you be more detailed?
What do you mean by saying "convert before inserting"?
Could you give me some hint/example?

aducom · Post by **aducom** » 14.02.2007, 09:26

There are in Delphi UTF8 conversion routines you might use. If you don't need to be database independent you might want to try one of the SQLite-only wrappers as can be found on www.sqlite.org.