"Wili" <wilhelm.n...@bfw.gv.at> wrote in
message news:23741187.p...@talk.nabble.com
> it is possible using charset ISO-8859-1 in sqlite?

No, not really. Convert your strings to UTF-8 before passing them to 
SQLite, and to whatever encoding you want when getting them out.

Now, you could probably get away with storing ill-formed UTF-8 strings 
(which is what ISO-8859-1 strings are, as far as SQLite is concerned), 
as long as all you do is put them into the database and get them out 
later. Comparing them, calling things like length() or substr() on them, 
searching them with LIKE operator and so on would likely produce 
incorrect results. All in all, it's a bad idea, don't do it if you could 
possibly avoid it.

Igor Tandetnik



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to