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 - UTF8->UTF16 JCD> There are 16-bit SQLite APIs for that, no conversion needed JCD> actually. But of course it all depends of the wrapper you use, if any. -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users