Subject | Re: LIKE operator and UNICODE_FSS |
---|---|
Author | mailmur |
Post date | 2004-12-31T12:53:37Z |
> a select with the LIKE operator fails if the parameter contains nonASCII-characters.
>As far as I know, FB does not fully support unicode strings. Many
> the problem was previously reported here:
>
> http://forums.devshed.com/showthread.php?p=425981#post425981
>
> is this fixed? or is here any work-arround?
string function can only handle ansi-ascii letters only. Same applies
to "number_of_characters != number_of_bytes" issue in unicode
characters, which give a nice side effect on varchar columns.
http://koti.mbnet.fi/akini/ib/
http://koti.mbnet.fi/akini/ib/unicode.html