Re: [sqlite] Cyrillic support

2012-03-10 Thread Teg
Hello Jean-Christophe, Good point. My application is 100% UTF-8 so, I probably think in just UTF-8. C Saturday, March 10, 2012, 4:38:00 PM, you wrote: >>You just need to convert it to UTF-8 before insert, then convert it >>back when you pull the data. >> >>UTF-16->UTF8 - insert >>Select -

Re: [sqlite] Cyrillic support

2012-03-10 Thread Jean-Christophe Deschamps
You just need to convert it to UTF-8 before insert, then convert it back when you pull the data. UTF-16->UTF8 - insert Select - UTF8->UTF16 There are 16-bit SQLite APIs for that, no conversion needed actually. But of course it all depends of the wrapper you use, if any.

Re: [sqlite] Cyrillic support

2012-03-10 Thread Teg
Hello Mite, You just need to convert it to UTF-8 before insert, then convert it back when you pull the data. UTF-16->UTF8 - insert Select - UTF8->UTF16 Or whatever encoding you use. I insert and retrieve full asian languages using UTF-8 conversions. You should be using UTF-8 for

Re: [sqlite] Cyrillic support

2012-03-10 Thread Jean-Christophe Deschamps
I am using the newest version of SQLite. How do I enable support for Cyrillic letters? Whenever I enter something in the DB with Cyrillic letters it gets saved like this ?? This would happen if your Unicode Cyrillic text gets "converted" (read "emasculated") to ANSI using a non-cyrillic

Re: [sqlite] Cyrillic support

2012-03-10 Thread Alek Paunov
On 10.03.2012 19:07, Mite wrote: I am using the newest version of SQLite. How do I enable support for Cyrillic letters? Whenever I enter something in the DB with Cyrillic letters it gets saved like this ?? I don't think so. Please try the attached shell script. Also, you can check this

[sqlite] Cyrillic support

2012-03-10 Thread Mite
I am using the newest version of SQLite. How do I enable support for Cyrillic letters? Whenever I enter something in the DB with Cyrillic letters it gets saved like this ?? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org