SQL not handling Unicode

[jda]

Hi Ruslan,

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).

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

Jon