client encoding mismatch

Hello ,

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

Can anybody tell me in what is trouble? Or what I shoud do with this
error?

When I try to set encoding manualy I have the next log:

conn=16465264, 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='WIN1251'',conn_encoding='WIN'
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=0 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='WIN'
conn=16465264, 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=16465264, query='set DateStyle to 'ISO''
conn=16465264, query='set geqo to 'OFF''
conn=16465264, query='set extra_float_digits to 2'
conn=16465264, query='conn_encoding='WIN1251''
STATEMENT ERROR: func=SC_execute, desc='', errnum=27, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=16465264, stmt=16476872, result=16457496
manual_result=1, prepare=0, internal=1
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=-1, statement='conn_encoding='WIN1251''
stmt_with_params='conn_encoding='WIN1251''
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR00FB6AC8'
----------------QResult Info -------------------------------
fields=16457632, manual_tuples=0, backend_tuples=0, tupleField=0, conn=16465264
fetch_count=101, num_total_rows=0, num_fields=0, cursor='(NULL)'
message='(NULL)', command='(NULL)', notice='(NULL)'
status=7, inTuples=1
CONN ERROR: func=SC_execute, desc='', errnum=108, errmsg='ERROR: syntax error at or near "conn_encoding" у символа 1'
------------------------------------------------------------
henv=16465208, conn=16465264, status=0, num_stmts=16
conn=16465264, query='select oid from pg_type where typname='lo''
[ Large Object oid = 16609 ]
conn=16465264, 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=16465208, conn=16465264, status=0, num_stmts=16

HEEELP!!! :(

--
Andrey Repko mailto:repko(at)sart(dot)must-ipra(dot)com