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
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]
