Re: upper and UTF-8 - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: upper and UTF-8
Date
Msg-id AANLkTimm5WHsxd7SoOV=72kP_D0XOUvS5y4j_HE8u81J@mail.gmail.com
Whole thread Raw
In response to Re: upper and UTF-8  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
Responses Re: upper and UTF-8  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
On Mon, Jul 26, 2010 at 3:47 PM, Benjamin Krajmalnik <kraj@servoyant.com> wrote:
> Unfortunately, the database has to accept data in multiple languages, since it is a SaaS offering.

The encoding determines that, not the collation.  UTF-8 allows you to
insert various languages in that encoding.

> It is not a big deal - I just found it interesting that it did not uppercase the accented letters.

Just tested it and the lc_collate seems to make the difference.

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Re: upper and UTF-8
Next
From: Scott Marlowe
Date:
Subject: Re: upper and UTF-8