Zeoslib Portal

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.

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

Hi,

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

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.