Thorsten Glaser, 2011-12-02 11:37:48 +0100 : > On Fri, 2 Dec 2011, Roland Mas wrote: > > [ A PostgreSQL database with UTF-8 encoding can ] >> only be created if the system locale is either C, POSIX, or an UTF-8 >> locale. When the system locale that has a different encoding (such as > > Eh, why?
I don't know. Ask PostgreSQL guys, I'm just a lowly user :-) >> Latin-9 in your case), new databases can only be created with that same >> encoding (see [1] for details). > > Can’t we “just” force C then? (For lc_messages anyway, and maybe > for lc_collate too… oh but for lc_ctype we definitively need a > UTF-8 locale or C.UTF-8 which is wheezy-specific though.) My understanding is that the locale that is considered is the one that the PostgreSQL daemon runs under; that means the whole cluster, and I'm not comfortable changing settings that affect unrelated databases. > Hrm. So PostgreSQL seems to only support Unicode when the OS below > does? (Consider a Recommends, or even Depends, on locales-all?) Not sure on the details, but that would seem logical. I'm not sure the dependencies are warranted, though, since it can run even on a locale-less system, and people who need a language-aware database will probably have the appropriate locale already. Roland. -- Roland Mas La menace de la baffe pèse plus lourd que la baffe elle-même. -- in Sri Raoul le petit yogi (Gaudelette) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org