Re: [ADMIN] upper and UTF-8

2010-07-27 Thread Michael Gould
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" wrote: > > >I just used the upper(text) function on a database which i

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Alvaro Herrera
Excerpts from Scott Marlowe's message of lun jul 26 23:12:08 -0400 2010: > On Mon, Jul 26, 2010 at 8:09 PM, Alvaro Herrera > wrote: > > I suspect that the problem is an incorrect client_encoding setting. > > Yeah, OP had set lc_collate to C under the mistaken impression that > collation controll

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Scott Marlowe
On Mon, Jul 26, 2010 at 8:09 PM, Alvaro Herrera wrote: > Excerpts from Benjamin Krajmalnik's message of lun jul 26 17:03:54 -0400 2010: >> 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 conve

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Alvaro Herrera
Excerpts from Benjamin Krajmalnik's message of lun jul 26 17:03:54 -0400 2010: > 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. FWIW it wor

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Scott Marlowe
On Mon, Jul 26, 2010 at 3:51 PM, Scott Marlowe wrote: > On Mon, Jul 26, 2010 at 3:47 PM, Benjamin Krajmalnik > 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 t

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Scott Marlowe
On Mon, Jul 26, 2010 at 3:47 PM, Benjamin Krajmalnik 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 d

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Benjamin Krajmalnik
dropped. > -Original Message- > From: Scott Marlowe [mailto:scott.marl...@gmail.com] > Sent: Monday, July 26, 2010 3:39 PM > To: Benjamin Krajmalnik > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] upper and UTF-8 > > I'd try creating a db with en_US or ev

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Scott Marlowe
LATE = 'C' >       LC_CTYPE = 'C' >       CONNECTION LIMIT = -1; > > >> -Original Message- >> From: Scott Marlowe [mailto:scott.marl...@gmail.com] >> Sent: Monday, July 26, 2010 3:17 PM >> To: Benjamin Krajmalnik >> Cc: pgsql-admin@

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Benjamin Krajmalnik
2010 3:17 PM > To: Benjamin Krajmalnik > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] upper and UTF-8 > > On Mon, Jul 26, 2010 at 3:03 PM, Benjamin Krajmalnik > wrote: > > I just used the upper(text) function on a database which is utf8 > encoded and >

Re: [ADMIN] upper and UTF-8

2010-07-26 Thread Scott Marlowe
On Mon, Jul 26, 2010 at 3:03 PM, Benjamin Krajmalnik 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. What are your various LC_* var