| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL, UTF-8 and Mac OS X |
| Date: | 2005-11-07 13:07:26 |
| Message-ID: | 20051107130726.GB841@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 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.
Sometime in the near future (hopefully) PostgreSQL will provide locale
support independant of the underlying operating system, but for now
you're stuck.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guido Neitzer | 2005-11-07 13:28:05 | Re: PostgreSQL, UTF-8 and Mac OS X |
| Previous Message | Peter Filipov | 2005-11-07 12:09:40 | Re: I just can't get it:record_in, record_out(I know i try to do something postgres is not developed for but there are many 'buts') |