[V4RB2] SQL REGEX Help

[Ivan Smahin]

Hello Charles,

Wednesday, June 29, 2005, 6:14:19 PM, you wrote:


CY> On Jun 29, 2005, at 10:29 AM, Ruslan Zasukhin wrote:

>> On 6/29/05 5:12 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:
>>
>>>> I think there is something about "CollationAtribute", but I can't
>>>> find enough explanation about these new features.
>>>> All I get from a Spotlight search is description of possible values
>>>> with no "how to" use them.
>>>
>>> Collations are someting to do about sorting and not about a RegEx
>>> search.
>>
>> 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.


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua