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

---------------------------(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