Re: [GENERAL] PostgreSQL, UTF-8 and Mac OS X

2005-11-07 Thread Martijn van Oosterhout
On Mon, Nov 07, 2005 at 09:47:21AM -0500, Tom Lane wrote: > Guido Neitzer <[EMAIL PROTECTED]> writes: > > I have linked the LC_COLLATE for de_DE.UTF-8 to the same LC_COLLATE > > file that works fine with ISO8859-1. > > Um ... why would you expect that to work at all? Aren't the collation > file

Re: [GENERAL] PostgreSQL, UTF-8 and Mac OS X

2005-11-07 Thread Tom Lane
Guido Neitzer <[EMAIL PROTECTED]> writes: > I have linked the LC_COLLATE for de_DE.UTF-8 to the same LC_COLLATE > file that works fine with ISO8859-1. Um ... why would you expect that to work at all? Aren't the collation files very dependent on the encoding? regards, to

Re: [GENERAL] PostgreSQL, UTF-8 and Mac OS X

2005-11-07 Thread Martijn van Oosterhout
On Mon, Nov 07, 2005 at 02:28:05PM +0100, Guido Neitzer wrote: > I think I was the one who asked. > > I worked on my locale problem on the weekend and was able to build a > LC_COLLATE file, that actually works with ISO locales, but not with > UTF-8 (50% progress ... ;-)). Guess the problem is

Re: [GENERAL] PostgreSQL, UTF-8 and Mac OS X

2005-11-07 Thread Guido Neitzer
On 07.11.2005, at 14:07 Uhr, Martijn van Oosterhout wrote: We had this question earlier this week. Mac OS X uses the locales from FreeBSD, and neither support UTF-8 collation at all. You'll see exactly the same results from other UNIX utilities. I think I was the one who asked. I worked on

Re: [GENERAL] PostgreSQL, UTF-8 and Mac OS X

2005-11-07 Thread Martijn van Oosterhout
On Mon, Nov 07, 2005 at 12:50:18PM +0100, Guido Neitzer wrote: > Hi. > > I have a problem with PostgreSQL and UTF-8 on my Mac OS X Powerbook. > > > - System is Mac OS X Client 10.4.3, PostgreSQL 8.1beta3 > > - initdb was called with -E UTF-8 --locale=de_DE.UTF-8 We had this question earlier th

[GENERAL] PostgreSQL, UTF-8 and Mac OS X

2005-11-07 Thread Guido Neitzer
Hi. I have a problem with PostgreSQL and UTF-8 on my Mac OS X Powerbook. - System is Mac OS X Client 10.4.3, PostgreSQL 8.1beta3 - initdb was called with -E UTF-8 --locale=de_DE.UTF-8 I have successfully build a LC_COLLATE file for ISO8859-15, and ordering works there if I do the initdb wit