>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.
Yes, I know it can be done that way. BTW, I'm not using Unicode. :)
I meant
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 >
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.
--
Miguel
3 matches
Mail list logo