Thanks you for all information, i am using turbo delphi, exists a function UTF8Decode, i am using it for solve de problem, it function convert of UTF-8 to WideString.
> 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] > ----------------------------------------------------------------------------- > > ------------------------------------------------ CiberCorreos® Acercando las Nuevas Tecnologías a la población. http://www.ciudadano.cu/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
