CREATE DATABASE ishield WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' CONNECTION LIMIT = -1; > -----Original Message----- > From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] > Sent: Monday, July 26, 2010 3:17 PM > To: Benjamin Krajmalnik > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: upper and UTF-8 > > On Mon, Jul 26, 2010 at 3:03 PM, Benjamin Krajmalnik > <kraj@xxxxxxxxxxxxx> 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_* variables for that database? > > -- > To understand recursion, one must first understand recursion. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin