"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