Skip site navigation (1) Skip section navigation (2)

Re: upper and UTF-8

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 (view raw or flat)
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.
>
>
> 
>
>
>

 



In response to

pgsql-admin by date

Next:From: Lou PiccianoDate: 2010-07-27 15:23:50
Subject: pl/PHP build on PostgreSQL v9 beta?
Previous:From: ALEXANDER JOSEDate: 2010-07-27 14:03:34
Subject: Postgresql for Windows 7

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group