Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id C186F632B2E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 27 Jul 2010 12:18:57 -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 07268-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 27 Jul 2010 15:18:49 +0000 (UTC)
X-Greylist: delayed 00:24:32.121958 by SQLgrey-1.7.6
Received: from serv01.siteground178.com (ns1.siteground178.com [67.15.255.19])
	by mail.postgresql.org (Postfix) with ESMTP id 8F9AF632A0D
	for <pgsql-admin@postgresql.org>; Tue, 27 Jul 2010 12:18:49 -0300 (ADT)
Received: from [67.15.255.19] (port=42215
 helo=intermodalsoftwaresolutions.net)
	by serv01.siteground178.com with esmtpa (Exim 4.69)
	(envelope-from <mgould@intermodalsoftwaresolutions.net>)
	id 1OdlXr-0002kn-60; Tue, 27 Jul 2010 09:54:15 -0500
Received: from phpmailer ([76.106.235.204])
	by intermodalsoftwaresolutions.net with HTTP (PHPMailer);
	Tue, 27 Jul 2010 09:54:15 -0500
Date: Tue, 27 Jul 2010 09:54:15 -0500
To: Benjamin Krajmalnik <kraj@servoyant.com>, pgsql-admin@postgresql.org
From: Michael Gould <mgould@intermodalsoftwaresolutions.net>
Subject: Re: upper and UTF-8
Message-ID: <7b16f36ed403d2ac22ac1c93073c41ed@intermodalsoftwaresolutions.net>
X-Priority: 3
X-Mailer: PHPMailer [version 1.71]
X-Mailer: FeLaMiMail
In-Reply-To: <F4E6A2751A2823418A21D4A160B689886147CA@fletch.stackdump.local>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="b1_7b16f36ed403d2ac22ac1c93073c41ed"
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - serv01.siteground178.com
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - intermodalsoftwaresolutions.net
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201007/188
X-Sequence-Number: 35207


--b1_7b16f36ed403d2ac22ac1c93073c41ed
Content-Type: text/plain; charset = "iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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


=A0


"Benjamin Krajmalnik" <kraj@servoyant.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.
>
>
>=A0
>
>
>

=A0




--b1_7b16f36ed403d2ac22ac1c93073c41ed
Content-Type: text/html; charset = "iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<p>Benjamin,</p>
<p>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.</p>
<p>Best Regards</p>
<p>Mike Gould</p>
<p>&#160;</p>
<p>"Benjamin Krajmalnik" &lt;kraj@servoyant.com&gt; wrote:</p>
<blockquote type=3D"cite">
<div>
<p>I just used the upper(text) function on a database which is utf8 =
encoded and which has spanish text.</p>
<p>All of the regular characters were properly converted, except for =
characters which had accents.</p>
<p>&#160;</p>
</div>
</blockquote>
<p>&#160;</p>



--b1_7b16f36ed403d2ac22ac1c93073c41ed--