As I understand it, sqlite upper and lower functions only work on
ASCII. There is an icu extension to make it work with UTF-8/UTF-16 as
far as I know.
Cheers,
Shawn
2008/2/10 Zbigniew Baniewski <[EMAIL PROTECTED]>:
> #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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
