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