#v+
SQLite version 3.5.4
Enter ".help" for instructions
sqlite> select lower(A);
SQL error: no such column: A
sqlite> select lower('A');
a
sqlite> select lower('Ą');
Ą
sqlite> select lower('ŻŹĆ');
ŻŹĆ
sqlite> select upper('ążźć');
ążźć
sqlite> select upper('asdf');
ASDF
#v-As one can see, the lower/upper functions aren't working at all for 8-bit non iso8859-1 characters (as I understand, this is the origin of a bug in "LIKE", mentioned on http://www.sqlite.org/lang_expr.html#like ? ). It's a serious problem for every language other than english. Any schedule for a fix? -- pozdrawiam / regards Zbigniew Baniewski _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
