> Peter Vicen ([EMAIL PROTECTED]) reports a bug with a severity of 3
> The lower the number the more severe it is.
> 
> Short Description
> lower and to_ascii don't work with UTF8
> 
> Long Description
> String functions (to_ascii and lower tested) don't work with UTF8.

Regarding to_ascii:

"The to_ascii function supports conversion from LATIN1, LATIN2,
WIN1250 (CP1250) only." So it's clearly not a bug:-)

For lower, I guess it is because your OS does not support UTF-8
locale. So it's not PostgreSQL's fault. Possible workaround might be:

lower(convert('your_utf8_string', 'LATIN1'))

Of course this would only work if you use only LATIN1 characters in
UTF-8.
--
Tatsuo Ishii

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to