| Lists: | pgsql-bugs |
|---|
| From: | pgsql-bugs(at)postgresql(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug #654: lower and to_ascii don't work with UTF8 |
| Date: | 2002-05-02 09:43:04 |
| Message-ID: | 20020502094304.F230E47601D@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Peter Vicen (vicen(at)pv2c(dot)sk) 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.
Sample Code
No file was uploaded with this report
| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | vicen(at)pv2c(dot)sk, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug #654: lower and to_ascii don't work with UTF8 |
| Date: | 2002-05-02 10:01:40 |
| Message-ID: | 20020502190140C.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
> Peter Vicen (vicen(at)pv2c(dot)sk) 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