[sqlite] Re: problem with tilde
[EMAIL PROTECTED] wrote: Hello, somebody know why the tilde do not show correctly. I am using Turbo Delphi and the unit SQLiteTable3 for access to the database in sqlite 3, but, the text that I see is, for example: Calcula la media móvil simple it must be Calcula la media móvil simple Whatever tool you are using for display does not handle UTF-8. 'ó' is encoded with two bytes in UTF-8, but your display program shows each byte as if it were a separate character. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Re: problem with tilde
> [EMAIL PROTECTED] wrote: >> Hello, somebody know why the tilde do not show correctly. >> I am using Turbo Delphi and the unit SQLiteTable3 for access to the >> database in sqlite 3, but, the text that I see is, for example: >> >> Calcula la media móvil simple >> >> it must be >> >> Calcula la media móvil simple > > Whatever tool you are using for display does not handle UTF-8. 'ó' is > encoded with two bytes in UTF-8, but your display program shows each > byte as if it were a separate character. > > Igor Tandetnik > > > I am using SQliteSpy 1.5.5 for to execute de sql statement for fill the table. In the menu Execute of SQliteSpy exist the element "text to unicode conversion", i convert the database to UTF-8 but the problem continue. - > 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] -
Re: [sqlite] Re: problem with tilde
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] -
Re: [sqlite] Re: problem with tilde
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] -