Re: How to find correct locale name for CREATEDATABASE
От | Andrus |
---|---|
Тема | Re: How to find correct locale name for CREATEDATABASE |
Дата | |
Msg-id | FA8EBBDD90A64C569E427DC3CD737E48@andrusnotebook обсуждение исходный текст |
Ответ на | Re: How to find correct locale name for CREATEDATABASE (Alban Hertroys <dalroi@solfertje.student.utwente.nl>) |
Ответы |
Re: How to find correct locale name for CREATEDATABASE
Re: How to find correct locale name for CREATEDATABASE |
Список | pgsql-general |
> However, if the locale that your database needs isn't available, what did > you intend to do about that? You can't just pick a different one, it > probably wouldn't behave the same. Apparently you can't just use the > default locales either, or you wouldn't be asking about this. I'm trying to create portable application which can automatically create database using estonian locale in any server. Postgres returns different values for same locale: In Fedora et_EE.UTF8 Other linuxes et_EE.UTF-8 In Windows Estonian_Estonia.1257 In some other Linuxes something like Estonian.Estonia For this reason I'm looking for a way to probe server for locale existence. > If the locale you need isn't available on the server and you don't have > shell access to it, then you'll have to contact the server administrators > to _make_ the locale available. > That means that either the OS doesn't have the required locale, or the > database cluster was initialised with an incompatible default locale - > neither of these situations can be solved by trying CREATE DATABASE with a > different locale, not if the locale mattered in the first place. My locale may be available but it can have at least four different values depending on server. No need to disturb admins. Andrus.
В списке pgsql-general по дате отправления: