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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
