| From: | Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net> |
|---|---|
| To: | Benjamin Krajmalnik <kraj(at)servoyant(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: upper and UTF-8 |
| Date: | 2010-07-27 14:54:15 |
| Message-ID: | 7b16f36ed403d2ac22ac1c93073c41ed@intermodalsoftwaresolutions.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Benjamin,
We're using the contrib module citext for all text columns so that we can
do case insensitive searches and so far we haven't found any that it
doesn't find.
Best Regards
Mike Gould
"Benjamin Krajmalnik" <kraj(at)servoyant(dot)com> wrote:
>
>
>I just used the upper(text) function on a database which is utf8 encoded
>and which has spanish text.
>
>
>All of the regular characters were properly converted, except for
>characters which had accents.
>
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lou Picciano | 2010-07-27 15:23:50 | pl/PHP build on PostgreSQL v9 beta? |
| Previous Message | ALEXANDER JOSE | 2010-07-27 14:03:34 | Postgresql for Windows 7 |