Thread: Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32

> John Hansen wrote:
> > currently, upper/lower does not work with 2+ byte unicode
> characters,
> > on any OS under the C locale.
>
> Sure it does.  It's just that the defined behavior of the C
> locale is often useless in practice.

select upper('æøå');
ERROR:  invalid multibyte character for locale
HINT:  The server's LC_CTYPE locale is probably incompatible with the database encoding.

Consequently it seems that is does not work.

... John

"John Hansen" <john@geeknet.com.au> writes:
>> Sure it does.  It's just that the defined behavior of the C
>> locale is often useless in practice.

> select upper('æøå');
> ERROR:  invalid multibyte character for locale
> HINT:  The server's LC_CTYPE locale is probably incompatible with the database encoding.

> Consequently it seems that is does not work.

"It fails on my machine" should not be read as "it doesn't work for anyone".
It all depends on how your local mbstowcs() works.

            regards, tom lane