• 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: UTF-8 and PostgreSQL problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: UTF-8 and PostgreSQL problem


  • Subject: Re: UTF-8 and PostgreSQL problem
  • From: Guido Neitzer <email@hidden>
  • Date: Sat, 24 Dec 2005 14:24:37 +0100

On 24.12.2005, at 1:27 Uhr, Marcos Trejo Munguia wrote:

You should try to create the database with encoding LATIN1. At least this works for me on PostgreSQL 7.4.

Bad idea if all the other workflow is on UTF8.

But, nevertheless, with Mac OS X you can get only with Latin and other "basic encodings" correct ordering from PostgreSQL. But you have to build your own locale files.

I have made an LC_COLLATE file for german ISO8859-15 encoding which enables mostly correct ordering with PostgreSQL and accented characters (needs some work). With UTF8 it's just not possible to get a correctly ordered result from PostgreSQL on Mac OS X (no locale support for UTF8 in Mac OS X).

If you need this (correct ordering of results with PostgreSQL, UTF8 and accented characters) use Linux for the DB server. It just works there ... or use a helper class in Java and sort in memory.

cug


-- PharmaLine, Essen, GERMANY Software and Database Development


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

References: 
 >RE: UTF-8 and PostgreSQL problem (From: Marcos Trejo Munguia <email@hidden>)

  • Prev by Date: RE: UTF-8 and PostgreSQL problem
  • Next by Date: Re: UTF-8 and PostgreSQL problem
  • Previous by thread: RE: UTF-8 and PostgreSQL problem
  • Next by thread: Re: UTF-8 and PostgreSQL problem
  • Index(es):
    • Date
    • Thread