I was messing about with this and tried the following in sqlite expert professional
select unicode(lower(char(256))); I was quite surprised when it responded with the correct result 257. Looking at the sqlite3.c code I can’t see anything that suggests sqlite would handle lower() for non-ascii characters so I tried the same thing in a c programme and it came back with the expected wrong answer 256. Am I right in saying 256 is the expected sqlite answer? Can anyone suggest why it works in the former? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users