database locale and system locale
От | Erwin Brandstetter |
---|---|
Тема | database locale and system locale |
Дата | |
Msg-id | 442624FF.6000604@falter.at обсуждение исходный текст |
Ответы |
Re: database locale and system locale
|
Список | pgsql-admin |
Hi everyone! I've been reading tons of stuff on locale and postgresql. I am still not in the clear about some details, though: how do system locale and database locale work together (or not)? (In my case, I am speaking of postgresql 8.1 on debian sarge. But general understanding is what I am looking for.) If I am running a database cluster with --encoding= UTF8, are there any troubles to be expected if the system locale remains "C" or somehting like "de_AT.iso885915@euro"? Any troubles with error messages, dumps, hacking the dump, performance? Any trouble at all? Is it enough to have an UTF8 locale installed on the system? postgres@dbneu:~$ locale -a C de_AT.utf8@euro Or does it actually have to be the system locale? postgres@dbneu:~$ locale LC_ALL="de_AT.UTF-8@euro" Do multiple UTF8 system locales have any effect? postgres@dbneu:~$ locale -a C de_AT.utf8@euro en_US.utf8 Does anyone know these details? It would ease my mind. :) Thanx in advance! Regards Erwin Brandstetter
В списке pgsql-admin по дате отправления: