Skip site navigation (1) Skip section navigation (2)

Re: Bug #654: lower and to_ascii don't work with UTF8

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 (view raw or flat)
Thread:
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

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-05-02 16:53:45
Subject: Bug #655: win32 client and bytea column
Previous:From: Tatsuo IshiiDate: 2002-05-02 09:48:16
Subject: Re: Bug #653: Unable to insert binary data into BYTEA

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group