Thread: 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:
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 > >> > >> > > > > > >