Skip site navigation (1) Skip section navigation (2)

Re: BUG #2071: ERROR: invalid multibyte character for locale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tomas(at)tuxteam(dot)de (Tomas Zerolo)
Cc: Prakash Nair <prakashblr(at)hotmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2071: ERROR: invalid multibyte character for locale
Date: 2005-11-26 16:21:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
tomas(at)tuxteam(dot)de (Tomas Zerolo) writes:
> - What is the nevironment of the server process? That is: what does the
>   shell command 'locale' say when it is issued in the same environment
>   as the server starts? (that is not necessarily the environment you get
>   if you start a shell!). Try, e.g. putting ''export LANG=us_US.UTF-8''
>   just before the server is called (typically in /etc/init.d/postgresql
>   or thereabout.

In recent PG versions you can do SHOW LC_COLLATE and/or SHOW LC_CTYPE
to verify the locale settings the server is using.  Note that these are
locked down based on the environment seen by initdb --- you can't change
them just by inserting an environment setting into the postmaster start

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2005-11-26 16:39:31
Subject: Re: BUG #2072: CPPFLAGS clobbered
Previous:From: Kishore NegiDate: 2005-11-26 09:37:13
Subject: Hi

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group