client encoding mismatch

Hello all,

conn=16530880, PGAPI_DriverConnect( in)='DSN=dep2_try;', fDriverCompletion=0
DSN info: DSN='dep2_try',server='127.0.0.1',port='5544',dbase='template1',user='postgres',passwd='xxxxx'
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
Global Options: Version='08.01.0004', fetch=100, socket=8192, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
conn=16530880, query='select version()'
[ PostgreSQL version string = 'PostgreSQL 8.1beta2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)' ]
[ PostgreSQL version number = '8.1' ]
conn=16530880, query='set DateStyle to 'ISO''
conn=16530880, query='set geqo to 'OFF''
conn=16530880, query='set extra_float_digits to 2'
conn=16530880, query='select oid from pg_type where typname='lo''
[ Large Object oid = 16609 ]
conn=16530880, query='select pg_client_encoding()'
[ Client encoding = 'WIN1251' (code = 22) ]
Client encoding = 'WIN1251' and WIN
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=214, errmsg='client encoding mismatch'
------------------------------------------------------------
henv=16530824, conn=16530880, status=0, num_stmts=16

Maybe this information can be helpful:

Run at PG 8.1
-----------
select pg_client_encoding();
result = WIN1251
--------------
Run at PG 8.0
-----------
select pg_client_encoding();
result = WIN
--------------

Subj error occur only on PG 8.1, not 8.0.

At whatnew:
E.1.3.7. Encoding and Locale Changes

Rename some encodings to be more consistent and to follow international standards (Bruce)
UNICODE is now UTF8
ALT is now WIN866
WIN is now WIN1251
TCVN is now WIN1258

http://developer.postgresql.org/docs/postgres/release.html#RELEASE-8-1

--
С наилучшими пожеланиями,
Репко Андрей Владимирович mailto:repko(at)sart(dot)must-ipra(dot)com