<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>
<P>Thanks,</P>
<P>Prakash.<BR><BR></P></DIV>
<DIV></DIV>
<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: <I>Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us></I><BR>To: <I>tomas(at)tuxteam(dot)de (Tomas Zerolo)</I><BR>CC: <I>Prakash Nair <prakashblr(at)hotmail(dot)com>, pgsql-bugs(at)postgresql(dot)org</I><BR>Subject: <I>Re: [BUGS] BUG #2071: ERROR: invalid multibyte character for locale</I><BR>Date: <I>Sat, 26 Nov 2005 11:21:11 -0500</I><BR>tomas(at)tuxteam(dot)de (Tomas Zerolo) writes:<BR>> - What is the nevironment of the server process? That is: what does the<BR>> shell command 'locale' say when it is issued in the same environment<BR>> as the server starts? (that is not necessarily the environment you get<BR>> if you start a shell!). Try, e.g. putting ''export LANG=us_US.UTF-8''<BR>> just before the server is called (typically in /etc/init.d/postgresql<BR>> 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. 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> http://www.postgresql.org/docs/faq<BR></FONT></BLOCKQUOTE></div></html>