On Sun, Jul 24, 2011 at 4:39 PM, Andrew Leeder <and...@aslassociates.co.uk>wrote:
> I have a table with a TEXT field that does not return the same string that > was inserted. The character that misbehaves is Greek letter "Ø". In fact > any character from the high end of the ANSII or ASCII table shows the > problem. > ASCII actually stops at 127, so anything above that is no longer ASCII. There are about a bazillion different 8-bit encodings based off of ASCII, which define what lives at bits 128-255. i suspect you're using latin1, which is not utf8-compatible (but is ascii-compatible up to value 127). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
