Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 75C3E6329E1 for ; Mon, 26 Jul 2010 18:18:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 79924-02 for ; Mon, 26 Jul 2010 21:18:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.illumen.com (unknown [64.207.29.137]) by mail.postgresql.org (Postfix) with ESMTP id 437AC632CC4 for ; Mon, 26 Jul 2010 18:18:17 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: upper and UTF-8 Date: Mon, 26 Jul 2010 15:18:15 -0600 Message-ID: In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] upper and UTF-8 Thread-Index: AcstB+23gmeuxlDsRv2YhWHB/MS9MQAABw1A References: From: "Benjamin Krajmalnik" To: "Scott Marlowe" Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201007/176 X-Sequence-Number: 35195 CREATE DATABASE ishield WITH OWNER =3D postgres ENCODING =3D 'UTF8' LC_COLLATE =3D 'C' LC_CTYPE =3D 'C' CONNECTION LIMIT =3D -1; > -----Original Message----- > From: Scott Marlowe [mailto:scott.marlowe@gmail.com] > Sent: Monday, July 26, 2010 3:17 PM > To: Benjamin Krajmalnik > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] upper and UTF-8 >=20 > 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. >=20 > What are your various LC_* variables for that database? >=20 > -- > To understand recursion, one must first understand recursion.