Re: good use of locale-settings (lang=, lc_...=)

Your welcome,

I do believe that C still counts for your data (indexes will be created using C / no locale). You can however specify that a 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 remember correctly. This particular mailing list is really more for getting postgres running under cygwin which is why it is 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(at)iname(dot)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(at)iname(dot)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
> >>
> >>
> >
> >
> >