Re: UTF-8 and PostgreSQL problem
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