Re: [sqlite] Serious problem: lower/upper malfunction
It's OK, found a README... :] -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Serious problem: lower/upper malfunction
On Mon, Feb 11, 2008 at 02:23:54PM +0100, Z.B. wrote: > > There is an icu extension to make it work with UTF-8/UTF-16 as > > far as I know. > > Is it a special extension for SQLite? Perhaps someone could tell me, how one is supposed to use an extension http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/icu.c Yes, took that file - how to integrate that file with SQLite 3.5.4, to make lower/upper/LIKE properly working? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Serious problem: lower/upper malfunction
On Sun, Feb 10, 2008 at 10:11:24PM -0500, Shawn Wilsher wrote: > 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. Is it a special extension for SQLite? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Serious problem: lower/upper malfunction
#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
