Обсуждение: good use of locale-settings (lang=, lc_...=)

hello,

i installed postgresql and finally got it to run. now i installed
another (windows-)program and i came again to this very important
question: how to properly use/set the locale-variables?

my newly installed program needs the (windows-)system-variable "lang" to
be set to "de" (for me, so that i can read the menu-entries in my language).

i installed postgresql with the locale-setting "C".

now: will i run into troubles with my new-setted (and needed) "lang=de" var?

greetings
hans horwath
p.s.: is there a good summary for secure and long-term functioning
locale-settings?

I think this page will help you.

http://www.postgresql.org/docs/7.4/static/multibyte.html#MULTIBYTE-TRANSLATION-TABLE

On Tue, Jul 27, 2004 at 11:35:06AM +0200, zuhans@iname.com wrote:
> hello,
>
> i installed postgresql and finally got it to run. now i installed
> another (windows-)program and i came again to this very important
> question: how to properly use/set the locale-variables?
>
> my newly installed program needs the (windows-)system-variable "lang" to
> be set to "de" (for me, so that i can read the menu-entries in my language).
>
> i installed postgresql with the locale-setting "C".
>
> now: will i run into troubles with my new-setted (and needed) "lang=de" var?
>
> greetings
> hans horwath
> p.s.: is there a good summary for secure and long-term functioning
> locale-settings?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match

hello mike,

thank you for your link (sometimes it can be very useful to have a look into the docs... :-) ).

one special question: if i initialized my db with "C" and then use the "lang=de" - does this influence my db (sorting...) or is still "C" the value that counts for my data?

greetings
hans


Mike G schrieb:

I think this page will help you.

http://www.postgresql.org/docs/7.4/static/multibyte.html#MULTIBYTE-TRANSLATION-TABLE

On Tue, Jul 27, 2004 at 11:35:06AM +0200, zuhans@iname.com wrote: 

hello,

i installed postgresql and finally got it to run. now i installed 
another (windows-)program and i came again to this very important 
question: how to properly use/set the locale-variables?

my newly installed program needs the (windows-)system-variable "lang" to 
be set to "de" (for me, so that i can read the menu-entries in my language).

i installed postgresql with the locale-setting "C".

now: will i run into troubles with my new-setted (and needed) "lang=de" var?

greetings
hans horwath
p.s.: is there a good summary for secure and long-term functioning 
locale-settings?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your    joining column's datatypes do not match   

Your welcome,

I do believe that C still counts for your data (indexes will be created using C / no locale).  You can however specify
thata different locale's properties be used for some formatting options but not sorting. 

Chapter 20 in the docs, specifically 20.1.1 would help.

You could also check the pgsql-general mailing list.  Not too long ago there was quite a discussion on locale if I
remembercorrectly.  This particular mailing list is really more for getting postgres running under cygwin which is why
itis so quiet. 

You have reached my limit of knowledge on this subject.

HTH

Mike


On Wed, Jul 28, 2004 at 09:52:58PM +0200, zuhans@iname.com wrote:
> hello mike,
>
> thank you for your link (sometimes it can be very useful to have a look
> into the docs... :-) ).
>
> one special question: if i initialized my db with "C" and then use the
> "lang=de" - does this influence my db (sorting...) or is still "C" the
> value that counts for my data?
>
> greetings
> hans
>
>
> Mike G schrieb:
>
> >I think this page will help you.
> >
> >http://www.postgresql.org/docs/7.4/static/multibyte.html#MULTIBYTE-TRANSLATION-TABLE
> >
> >On Tue, Jul 27, 2004 at 11:35:06AM +0200, zuhans@iname.com wrote:
> >
> >
> >>hello,
> >>
> >>i installed postgresql and finally got it to run. now i installed
> >>another (windows-)program and i came again to this very important
> >>question: how to properly use/set the locale-variables?
> >>
> >>my newly installed program needs the (windows-)system-variable "lang" to
> >>be set to "de" (for me, so that i can read the menu-entries in my
> >>language).
> >>
> >>i installed postgresql with the locale-setting "C".
> >>
> >>now: will i run into troubles with my new-setted (and needed) "lang=de"
> >>var?
> >>
> >>greetings
> >>hans horwath
> >>p.s.: is there a good summary for secure and long-term functioning
> >>locale-settings?
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 9: the planner will ignore your desire to choose an index scan if your
> >>    joining column's datatypes do not match
> >>
> >>
> >
> >
> >