Miguel Angel Latorre Díaz wrote:
Shoudn't the LIKE and GLOB function use a collation if present (either in
column definition or by the COLLATE xxx word) ?
The new collation functions are used to compare strings, and that's what
LIKE and GLOB do (sort of).
That way it would correctly handle the > ASCII(127) characters.
You are correct that LIKE and GLOB only work for 7-bit ascii
strings. If you need a LIKE and GLOB that work with Unicode,
you can register alternative LIKE and GLOB functions using
the sqlite3_create_function() API.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
