Re: [BUGS] BUG #2071: ERROR: invalid multibyte character for locale

#1

tomas (AT) tuxteam (DOT) de (Tomas Zerolo) writes:

Quote:

- 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
script.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #2071: ERROR: invalid multibyte character for locale

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2071: ERROR: invalid multibyte character for locale - 11-26-2005 , 10:21 AM