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

From: "Prakash Nair" <prakashblr(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us, tomas(at)tuxteam(dot)de
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2071: ERROR: invalid multibyte character for locale
Date: 2005-11-27 11:00:07
Message-ID: BAY22-F176E5002D07E2A34B3E333C1490@phx.gbl
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-bugs

<html><div style='background-color:'><DIV class=RTE>
<P>Thanks All.</P>
<P>I have got a solution. When we give initdb, given it with --locale=C and created database with 'UNICODE'. </P>
<P>This one worked. as of now everything seems to be working. I hope , there wont be any issues, please let me know, if you have any suggestions.</P>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">
<HR color=#a0c6e5 SIZE=1>

<DIV></DIV>From:&nbsp;&nbsp;<I>Tom Lane &lt;tgl(at)sss(dot)pgh(dot)pa(dot)us&gt;</I><BR>To:&nbsp;&nbsp;<I>tomas(at)tuxteam(dot)de (Tomas Zerolo)</I><BR>CC:&nbsp;&nbsp;<I>Prakash Nair &lt;prakashblr(at)hotmail(dot)com&gt;, pgsql-bugs(at)postgresql(dot)org</I><BR>Subject:&nbsp;&nbsp;<I>Re: [BUGS] BUG #2071: ERROR: invalid multibyte character for locale</I><BR>Date:&nbsp;&nbsp;<I>Sat, 26 Nov 2005 11:21:11 -0500</I><BR>tomas(at)tuxteam(dot)de (Tomas Zerolo) writes:<BR>&gt; - What is the nevironment of the server process? That is: what does the<BR>&gt;&nbsp;&nbsp; shell command 'locale' say when it is issued in the same environment<BR>&gt;&nbsp;&nbsp; as the server starts? (that is not necessarily the environment you get<BR>&gt;&nbsp;&nbsp; if you start a shell!). Try, e.g. putting ''export LANG=us_US.UTF-8''<BR>&gt;&nbsp;&nbsp; just before the server is called (typically in /etc/init.d/postgresql<BR>&gt;&nbsp;&nbsp; or
thereabout.<BR><BR>In recent PG versions you can do SHOW LC_COLLATE and/or SHOW LC_CTYPE<BR>to verify the locale settings the server is using.&nbsp;&nbsp;Note that these are<BR>locked down based on the environment seen by initdb --- you can't change<BR>them just by inserting an environment setting into the postmaster start<BR>script.<BR><BR>regards, tom lane<BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 3: Have you checked our extensive FAQ?<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR></FONT></BLOCKQUOTE></div></html>

Attachment Content-Type Size
unknown_filename text/html 2.1 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Frank van Vugt 2005-11-28 11:19:02 segfault of autovacuum process during restore - coredumps included
Previous Message Bruce Momjian 2005-11-27 03:14:50 Re: Patch to allow contrib/pgbench files to have blank lines