Alexey Pechnikov <pechni...@...> writes:
>
> Hello!
>
> I'm try to do this in tcl with SQLIte 3.6.7:
>
> proc nocase_compare {a b} {
> return [string compare [string tolower $a] [string tolower $b]]
> }
> db collate NOCASE nocase_compare
>
> CREATE TABLE test (
> name TEXT --COLLATE NOCASE
> );
> insert into test values ('Привет!');
> insert into test values ('Ё-моё');
> insert into test values ('привет');
> insert into test values ('ё-прст');
> insert into test values ('ага!');
> insert into test values ('ё-моё');
>
...snip...
> Best regards, Alexey.
Surely this is a problem with Tcl's ability to sort non-ASCII characters
rather than SQLite ?
How about using Tcl_UniCharNcasecmp rather than 'string compare' ?
Хорошо!
MikeW
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
