Re: [sqlite] RE: UNICODE Support
Consider upgrading to 3.3.6. The following are some changes related to the UTF stuff. *2006 June 6 (3.3.6)* - Fix an obscure segfault in UTF-8 to UTF-16 conversions *2006 April 5 (3.3.5)* - The sqlite3_create_collation() function honors the SQLITE_UTF16_ALIGNED flag. On 8/4/06, RohitPatel <[EMAIL PROTECTED]> wrote: Hi Dennis Volodomanov I am using SQLite 3.3.4. My Win32 Application needs international language support (Chinese, Japanese). I need my Win32 Application to build such that, MBCS defined for Windows 98/ME and UNICODE (and _UNICODE) defined for Windows NT/2000/2003/XP. Can you help me by giving some sample code which inserts/selects/updates SQLite db (UTF-8) ? Also if you can help me with some guidelines from your experience regarding using SQLite db (UTF-8) for international languages ? Thank you for any help. Rohit -- View this message in context: http://www.nabble.com/UNICODE-Support-tf58444.html#a5644461 Sent from the SQLite forum at Nabble.com. -- Pablo
Re: [sqlite] RE: UNICODE Support
On 8/3/06, Cory Nelson <[EMAIL PROTECTED]> wrote: I recommend using utf-16 in the database - sqlite doesn't fully support utf-8, and some things may give unexpected results if you use it. As with others who have replied, I have not had a problem working with UTF8 in a SQLite database.
Re: [sqlite] RE: UNICODE Support
Cory Nelson wrote: I recommend using utf-16 in the database - sqlite doesn't fully support utf-8, and some things may give unexpected results if you use it. Could you expand a bit on this please? I haven't seen any bugs as such with sqlite as such but I did have a few problems storing "foreign" characters through the Python wrappers to sqlite, where the wrappers barfed converting the "foreign" character. In one case it was because the source (Windows app) lied about the encoding - it claimed the text was UTF-8 when it was windows-1252. In the other case the text came from a Unix box and was supposed to be 7-bit ASCII, but I suspect it was generated by a Windows app, as above. I think I've got this all sorted in my mind but if you say sqlite has issues handling UTF-8 then I need to look at it again. Martin
Re: [sqlite] RE: UNICODE Support
On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote: I recommend using utf-16 in the database - sqlite doesn't fully support utf-8, and some things may give unexpected results if you use it. Could you give some example of unexpected result with UTF-8? In my experience the only unexpected results with UTF-8 were bugs in my program (like passing non-UTF-8 string). Any other unexpected result should be considered a bug in SQLite and reported as such. Regards, ~Nuno Lucas -- Cory Nelson http://www.int64.org
Re: [sqlite] RE: UNICODE Support
On 8/3/06, RohitPatel <[EMAIL PROTECTED]> wrote: Hi Dennis Volodomanov I am using SQLite 3.3.4. My Win32 Application needs international language support (Chinese, Japanese). I need my Win32 Application to build such that, MBCS defined for Windows 98/ME and UNICODE (and _UNICODE) defined for Windows NT/2000/2003/XP. Can you help me by giving some sample code which inserts/selects/updates SQLite db (UTF-8) ? Also if you can help me with some guidelines from your experience regarding using SQLite db (UTF-8) for international languages ? I recommend using utf-16 in the database - sqlite doesn't fully support utf-8, and some things may give unexpected results if you use it. Thank you for any help. Rohit -- View this message in context: http://www.nabble.com/UNICODE-Support-tf58444.html#a5644461 Sent from the SQLite forum at Nabble.com. -- Cory Nelson http://www.int64.org
[sqlite] RE: UNICODE Support
Hi Dennis Volodomanov I am using SQLite 3.3.4. My Win32 Application needs international language support (Chinese, Japanese). I need my Win32 Application to build such that, MBCS defined for Windows 98/ME and UNICODE (and _UNICODE) defined for Windows NT/2000/2003/XP. Can you help me by giving some sample code which inserts/selects/updates SQLite db (UTF-8) ? Also if you can help me with some guidelines from your experience regarding using SQLite db (UTF-8) for international languages ? Thank you for any help. Rohit -- View this message in context: http://www.nabble.com/UNICODE-Support-tf58444.html#a5644461 Sent from the SQLite forum at Nabble.com.