[V4RB2] SQL REGEX Help

[Ruslan Zasukhin]

On 6/29/05 6:37 PM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:

>>> Collation affect indexes, so searches and sorting,
>>> 
>>> LIKE also take this into account.
>>> 
>>> And I think REGEX also. Ivan ?
> No. Regex does not use collator. I think all collation attributes might be
> mentioned
> in the pattern self. Another reason is: collation with pattern string - it can
> be ambiguity
> here.

Ok, so AT LEAST now

    indexes, searches, sorting, LIKE -- take care on collation
    regex -- no

-- 
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]