[V4RB2] SQL REGEX Help

[Ruslan Zasukhin]

On 6/30/05 11:34 AM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

> Thank you Damon
> 
> Le 30 juin 2005 à 05:57, Damon Pillinger a écrit :
>> if you do this
>> WHERE Name LIKE '%eme%'
>> You should get anything with 'eme' in it similar to REGEDIT results.
> 
> Yes, that's true, I now get some records, instead of nothing.
> As I said, LIKE now uses SQL92, which I was not using in my tests.
> In v1, LIKE did not use this.
> 
> But there is something that I still don't figure out.
> 
> LIKE uses ICU collations, right?
> Both for SORT and SEARCH, as Ruslan wrote yesterday, right?
> 
> So, if my field "Name" has for CollationAttribute "Strength" =
> Primary ‹which is supposed to ignore accents and case‹, I should also
> get records such as :
> 7ème Apache
> 16/9 EME
> etc.
> ... which I don't get... I only get records with exactly 'eme' in
> their name. 'ème' and 'EME' are ignored...
> 
> I must have missed something again...

We can check this on your db ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]