SQL not handling Unicode

[Ruslan Zasukhin]

On 1/22/06 11:06 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I've created a sort method that ignores certain
> words at the beginning of a name. It works ONLY
> with ASCII characters -- accented characters
> don't work. Here is an example of relevant SQL in
> the method:
> 
> CASE WHEN LOCATE('züm
> ',coalesce(authors,editors))=1 THEN
> RIGHT(coalesce(authors,editors),
> LENGTH(coalesce(authors,editors)) - LENGTH('züm
> ')) ELSE coalesce(authors,editors) END
> 
> (it looks for the word 'züm' at the beginning of
> the field, and if it is there it returns the
> field without that word).

So function LOCATE() fails to find 'züm' ?

 
> If this should work, I'll file a bug report. If not, a feature request.

bug


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