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?
Expert v5 (I expect that's what you use) includes Unicode support and
overrides sqlite3.dll lower().
JcD
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
