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