• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: [OT] Postgresql capital accentuated characters problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [OT] Postgresql capital accentuated characters problem


  • Subject: Re: [OT] Postgresql capital accentuated characters problem
  • From: Ralf Schuchardt <email@hidden>
  • Date: Wed, 2 Apr 2008 13:33:11 +0200

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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


  • Follow-Ups:
    • Re: [OT] Postgresql capital accentuated characters problem
      • From: Miguel Arroz <email@hidden>
References: 
 >[OT] Postgresql capital accentuated characters problem (From: Miguel Arroz <email@hidden>)

  • Prev by Date: Re: an interesting lockRowComparingAttributes:
  • Next by Date: Re: WO 5.4 Linux Deployment
  • Previous by thread: [OT] Postgresql capital accentuated characters problem
  • Next by thread: Re: [OT] Postgresql capital accentuated characters problem
  • Index(es):
    • Date
    • Thread