aj wrote:
> what encoding does sqlite_exec() callback function receive data in ?
>
> some tests i've done seem to suggest UTF-8
>
> other tests show chars U+80 to U+FF are returned as single chars with
> values 128-255. (suggesting its not UTF-8)

This means that these strings were inserted this way into the database. 
You are getting them back the way you put them in.

SQLite functions that expect UTF-8 strings (e.g. sqlite3_bind_text) 
don't actually verify that the encoding is valid. It is your 
responsibility to pass a well-formed UTF-8 sequence. Apparently, you (or 
whoever filled the database with data) didn't.

Igor Tandetnik



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

Reply via email to