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

From John Hansen
Subject Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE5625C@rodrick.geeknet.com.au
Whole thread Raw
Responses Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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

pgsql-hackers by date:

Previous
From: jtv@xs4all.nl
Date:
Subject: Re: Finding if old transactions are running...
Next
From: Jeff Davis
Date:
Subject: idea for concurrent seqscans