> 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