This is a multi-part message in MIME format.
------_=_NextPart_001_01C8DFEE.C7F97FA8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi all,
I tried to look into the problem, still unable to solve the problem=2E
Problem details:
We have a custom application which installs Postgres 8=2E1=2E4=2E It=
provides
option for selection of encoding=2E
Below is the line which does the same based on the encoding selection:
"
msiexec /i postgresql-8=2E1-int=2Emsi /qn -l %LogFile%
ADDLOCAL=3Dserver,psql,pgadmin INTERNALLAUNCH=3D1 DOSERVICE=3D1 DOINITDB=
=3D1
SERVICEDOMAIN=3D"%COMPUTERNAME%" SERVICEACCOUNT=3D"postgres"
SERVICEPASSWORD=3D"Password1*2*3" SUPERPASSWORD=3D"postgres"
CREATESERVICEUSER=3D1 ENCODING=3D%Lang% LISTEN****T=3D7432 PERMITREMOTE=3D1
NOSHORTCUTS=3D1 BASEDIR=3D%JM_ROOT_WIN%\StdyDb
DATADIR=3D%JM_ROOT_WIN%\StdyDb\data
"
Where "Lang" is the selection done by user=2E
=20
I changed it to ENCODING=3D"UTF8" installation in UTF8 format=2E
=20
I installed the Postgres 8=2E1=2E4 version with UTF8 as encoding=2E This=
works
properly when my regional settings are Japanese but the same
installation fails as soon as I change my regional settings to Greek=2E
When I try to connect to the database with Greek regional settings it
throws the error "Client Encoding mismatch"=2E=20
=20
I feel there is some setting done at the installation time which makes
it work correctly in Japanese regional language settings only=2E Hence it
fails when I change them to Greek=2E
What can be the cause for this behavior? Do I need to change some
settings on cygwin or pgaccess side at installation time?
I even tried changing the encoding for database to Unicode still the
same error=2E (createdb -E UTF8 Xyz)=20
=20
=20
Note:-
I have even tried with direct installation of Postgres version
8=2E1=2E4=2E=
It
behaves in the same way as our Custom installer is behaving=2E It seems
there is problem in the version 8=2E1=2E4 itself=2E
Tom,
I think the error is thrown from the Postgres side only=2E I am getting
the same error while working with direct installer of Postgres=2E I get
this error with Greek and Thai regional language settings, not with
Japanese=2E=20
=20
Please help me on the same=2E
=20
=20
=20
Regards,
Ashutosh
=20
-----Original Message-----
From: Tom Lane [mailto:tgl@[EMAIL PROTECTED]
Thursday, June 26, 2008 8:29 PM
To: Ashutosh Kumar S-TLS,Chennai
Cc: pgsql-bugs@[EMAIL PROTECTED]
Re: [BUGS] error ' Client encoding Mismatch' with Version 8=2E1=
=2E4
=20
"Ashutosh Kumar S-TLS,Chennai" <ashutoshks@[EMAIL PROTECTED]
> writes:
> Problem is whenever I am trying to open the database through ODBC
> connection it throws an error 'Client encoding mismatch'=2E
=20
That phrase occurs noplace in Postgres 8=2E1, so the error must be coming
from something on the client side=2E We can't really help you here ---
you need to find out which bit of software is throwing the error and
ask its authors what is the cause=2E
=20
regards, tom lane
DISCLAIMER:
---------------------------------------------------------------------------=
--------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and=
intended for the named recipient(s) only=2E
It shall not attach any liability on the originator or HCL or its=
affiliates=2E Any views or opinions presented in=20
this email are solely those of the author and may not necessarily reflect=
the opinions of HCL or its affiliates=2E
Any form of reproduction, dissemination, copying, disclosure,
modification,=
distribution and / or publication of=20
this message without the prior written consent of the author of this
e-mail=
is strictly prohibited=2E If you have
received this email in error please delete it and notify the sender=
immediately=2E Before opening any mail and=20
attachments please check them for viruses and defect=2E
---------------------------------------------------------------------------=
--------------------------------------------
------_=_NextPart_001_01C8DFEE.C7F97FA8
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=
=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns:m=3D"http://schemas=
=2Emicrosoft=2Ecom/office/2004/12/omml" xmlns=3D"http://www=2Ew3=
=2Eorg/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@[EMAIL PROTECTED]
"Cordia New";
panose-1:2 11 3 4 2 2 2 2 2 4;}
@[EMAIL PROTECTED]
"Cordia New";
panose-1:2 11 3 4 2 2 2 2 2 4;}
@[EMAIL PROTECTED]
11 6 4 3 5 4 4 2 4;}
@[EMAIL PROTECTED]
11 6 9 2 2 4 3 2 4;}
@[EMAIL PROTECTED]
"\@[EMAIL PROTECTED]
Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p=2EMsoNormal, li=2EMsoNormal, div=2EMsoNormal
{margin:0in;
margin-bottom:=2E0001pt;
font-size:11=2E0pt;
font-family:"Calibri","sans-serif";}
a:link, span=2EMsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span=2EMsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p=2EMsoPlainText, li=2EMsoPlainText, div=2EMsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:=2E0001pt;
font-size:10=2E5pt;
font-family:Consolas;}
p=2EMsoAcetate, li=2EMsoAcetate, div=2EMsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:=2E0001pt;
font-size:8=2E0pt;
font-family:"Tahoma","sans-serif";}
span=2EPlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span=2EEmailStyle19
{mso-style-type:personal-compose;}
span=2EBalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
=2E=2EMsoChpDefault
{mso-style-type:ex****t-only;
font-size:10=2E0pt;}
@[EMAIL PROTECTED]
Section1
{size:8=2E5in 11=2E0in;
margin:1=2E0in 1=2E25in 1=2E0in 1=2E25in;}
div=2ESection1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoPlainText>Hi all,<o:p></o:p></p>
<p class=3DMsoPlainText>I tried to look into the problem, still unable to=
solve
the problem=2E<o:p></o:p></p>
<p class=3DMsoPlainText>Problem details:<o:p></o:p></p>
<p class=3DMsoPlainText>We have a custom application which installs=
Postgres
8=2E1=2E4=2E It provides option for selection of
encoding=2E<o:p></o:p></p>
<p class=3DMsoPlainText>Below is the line which does the same based on the
encoding selection:<o:p></o:p></p>
<p class=3DMsoPlainText>"<o:p></o:p></p>
<p class=3DMsoPlainText><span style=3D'color:#365F91'>msiexec /i
postgresql-8=2E1-int=2Emsi /qn -l %LogFile% ADDLOCAL=
=3Dserver,psql,pgadmin
INTERNALLAUNCH=3D1 DOSERVICE=3D1 DOINITDB=3D1
SERVICEDOMAIN=3D"%COMPUTERNAME%" SERVICEACCOUNT=
=3D"postgres" SERVICEPASSWORD=3D"Password1*2*3"
SUPERPASSWORD=3D"postgres" CREATESERVICEUSER=3D1 ENCODING=
=3D%Lang%
LISTEN****T=3D7432 PERMITREMOTE=3D1 NOSHORTCUTS=3D1 BASEDIR=
=3D%JM_ROOT_WIN%\StdyDb
DATADIR=3D%JM_ROOT_WIN%\StdyDb\data<o:p></o:p></span></p>
<p class=3DMsoPlainText>"<o:p></o:p></p>
<p class=3DMsoPlainText>Where “Lang” is the selection done by=
user=2E<o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>I changed it to <span style=
=3D'color:#365F91'>ENCODING=3D”UTF8”
</span>installation in UTF8 format=2E<o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>I installed the Postgres 8=2E1=2E4 version with=
UTF8 as
encoding=2E This works properly when my regional settings are Japanese
but=
the
same installation fails as soon as I change my regional settings to Greek=
=2E When
I try to connect to the database with Greek regional settings it throws
the
error "Client Encoding mismatch"=2E <o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>I feel there is some setting done at the=
installation
time which makes it work correctly in Japanese regional language settings=
only=2E
Hence it fails when I change them to Greek=2E<o:p></o:p></p>
<p class=3DMsoPlainText>What can be the cause for this behavior? Do I
need=
to
change some settings on cygwin or pgaccess side at installation=
time?<o:p></o:p></p>
<p class=3DMsoPlainText>I even tried changing the encoding for database to
Unicode still the same error=2E (createdb –E UTF8 Xyz)=
<o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>Note:-<o:p></o:p></p>
<p class=3DMsoPlainText><b>I have even tried with direct installation of=
Postgres
version 8=2E1=2E4=2E It behaves in the same way as our Custom installer
is=
behaving=2E It
seems there is problem in the version 8=2E1=2E4 itself=
=2E<o:p></o:p></b></p>
<p class=3DMsoPlainText><b>Tom,<o:p></o:p></b></p>
<p class=3DMsoPlainText><b>I think the error is thrown from the Postgres=
side
only=2E I am getting the same error while working with direct installer
of=
Postgres=2E
I get this error with Greek and Thai regional language settings, not with
Japanese=2E <o:p></o:p></b></p>
<p class=3DMsoPlainText><b><o:p> </o:p></b></p>
<p class=3DMsoPlainText><b>Please help me on the
same=2E<o:p></o:p></b></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>Regards,<o:p></o:p></p>
<p class=3DMsoPlainText>Ashutosh<o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>-----Original Message-----<br>
From: Tom Lane [mailto:tgl@[EMAIL PROTECTED]
<br>
Sent: Thursday, June 26, 2008 8:29 PM<br>
To: Ashutosh Kumar S-TLS,Chennai<br>
Cc: pgsql-bugs@[EMAIL PROTECTED]
>
Subject: Re: [BUGS] error ' Client encoding Mismatch' with Version 8=2E1=
=2E4 <o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>"Ashutosh Kumar S-TLS,Chennai" <<a
href=3D"mailto:ashutoshks@[EMAIL PROTECTED]
">ashutoshks@[EMAIL PROTECTED]
>>=
writes:<o:p></o:p></p>
<p class=3DMsoPlainText>> Problem is whenever I am trying to open the=
database
through ODBC<o:p></o:p></p>
<p class=3DMsoPlainText>> connection it throws an error 'Client
encoding
mismatch'=2E<o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=3DMsoPlainText>That phrase occurs noplace in Postgres 8=2E1, so=
the error
must be coming<o:p></o:p></p>
<p class=3DMsoPlainText>from something on the client side=2E We
can't=
really
help you here ---<o:p></o:p></p>
<p class=3DMsoPlainText>you need to find out which bit of software is=
throwing
the error and<o:p></o:p></p>
<p class=3DMsoPlainText>ask its authors what is the
cause=2E<o:p></o:p></p>
<p class=3DMsoPlainText><o:p> </o:p></p>
<p class=
=3DMsoPlainText>  =
; regards,
tom lane<o:p></o:p></p>
</div>
</body>
</html>
<table><tr><td bgcolor=3D#ffffff><font color=3D#000000>DISCLAIMER:<br>
---------------------------------------------------------------------------=
--------------------------------------------<br>
<br>
The contents of this e-mail and any attachment(s) are confidential and=
intended for the named recipient(s) only=2E<br>
It shall not attach any liability on the originator or HCL or its=
affiliates=2E Any views or opinions presented in <br>
this email are solely those of the author and may not necessarily reflect=
the opinions of HCL or its affiliates=2E<br>
Any form of reproduction, dissemination, copying, disclosure,
modification,=
distribution and / or publication of <br>
this message without the prior written consent of the author of this
e-mail=
is strictly prohibited=2E If you have<br>
received this email in error please delete it and notify the sender=
immediately=2E Before opening any mail and <br>
attachments please check them for viruses and defect=2E<br>
<br>
---------------------------------------------------------------------------=
--------------------------------------------<br>
</font></td></tr></table>
------_=_NextPart_001_01C8DFEE.C7F97FA8--
|
