[OT] Postgresql capital accentuated characters problem
[OT] Postgresql capital accentuated characters problem
- Subject: [OT] Postgresql capital accentuated characters problem
- From: Miguel Arroz <email@hidden>
- Date: Wed, 2 Apr 2008 02:34:22 +0100
Hi!
This is not exactly the most appropriate place to ask this, but
many of you use PgSQL and many of you work with accentuated
characters, so maybe some of you know what's going on here.
I created an UNIQUE INDEX using the lower() function to create a
case-insensitive UNIQUE constraint. I tested this and I noticed it's
failing on accentuated characters. The problem is this:
select lower('JoÃo');
lower
-------
joÃo
(1 row)
lower() is not "lowering" the accentuated characters.
I have created the cluster with -i UTF8 and the database with
ENCODING = 'UTF8'. My terminal is using UTF8 encoding (although this
also happens when using an WO app). This happens on Mac OS X and
FreeBSD. The PgSQL version is 8.3.
Does anyone know what the heck is going on here? I'm running out of
ideas, and I find almost no information about this on the net.
Yours
Miguel Arroz
Miguel Arroz
http://www.terminalapp.net
http://www.ipragma.com
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden