Hi Miguel,
I think you must initialize your database cluster with the correct
locale, to get this working (see http://www.postgresql.org/docs/8.3/
interactive/locale.html).
Ralf Schuchardt
Am 02.04.2008 um 03:34 schrieb Miguel Arroz:
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.
_______________________________________________
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]
