On Sun, Jun 21, 2009 at 05:12:18PM -0700, Cory Nelson wrote:
> Unfortunately, no. A correct toupper/tolower would require locale
> support and passing in a string pointer, not a char. Even a wide
> character can't store all the information needed to make something
> upper/lower.
OK, maybe different way then:
There is - in SQLite's TCL API - a "collate" method:
#v+
This method registers new text collating sequences. There are two
arguments: the name of the collating sequence and the name of a TCL
procedure that implements a comparison function for the collating sequence.
For example, the following code implements a collating sequence called
"NOCASE" that sorts in text order without regard to case:
proc nocase_compare {a b} {
return [string compare [string tolower $a] [string tolower $b]]
}
db collate NOCASE nocase_compare
#v-
Perhaps could be possible to add to that API something like external
"tolower/toupper" methods, that could be registered from within TCL?
--
pozdrawiam / regards
Zbigniew Baniewski
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
