Hello [EMAIL PROTECTED], > I am using SQliteSpy 1.5.5 for to execute de sql statement for fill the >table.
SQLiteSpy is fully Unicode enabled, including the SQL editor. Hence, it correctly stores text in whatever UTF format your database uses. This includes tilde as well as French accented characters, German umlauts, Russian cyrillic characters, and more. > In the menu Execute of SQliteSpy exist the element "text to unicode >conversion", i convert the database to UTF-8 but the problem continue. This is a convenience function if you want to convert non-Unicode text in your database to to Unicode. If you have used SQLiteSpy only to add your data, you will never need this function. The function was added because many applications wrongly pass non-UTF-8 text to SQLite functions and can help to convert those databases to Unicode. The Conversion will remedy display problems of non-Unicode characters (which show as an empty boxs with most fonts) in SQLiteSpy and other Unicode enabled software. However, you will receive display problems if you use the converted database in your old, non-Unicode application. In particular, I suspect that your SQLiteTable3 unit is not Unicode aware. You need to add UTF-8 conversion to your application. Alternatively, you can use Unicode enabled Delphi wrappers like DISQLite3 (http://www.yunqa.de/delphi/) instead which supports Delphi WideStrings with functions like: function sqlite3_bind_str16(const Stmt: TDISQLite3StatementHandle; const ParamIdx: Integer; const Data: WideString ): Integer; function sqlite3_column_str16(const Stmt: TDISQLite3StatementHandle; const Col: Integer ): WideString; which take care of the conversion for you automatically. Btw: SQLiteSpy internally uses the DISQLite3 for all its Unicode functions. Regards, Ralf ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
