Re: [sqlite] v3 like and collation

2004-07-22 Thread Miguel Angel Latorre Díaz
>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

Re: [sqlite] v3 like and collation

2004-07-21 Thread D. Richard Hipp
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 >

[sqlite] v3 like and collation

2004-07-21 Thread Miguel Angel Latorre Díaz
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