client encoding mismatch

Поиск
Список
Период
Сортировка
От Andrey Repko
Тема client encoding mismatch
Дата
Msg-id 2710025222.20050917140948@sart.must-ipra.com
обсуждение исходный текст
Список pgsql-odbc
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@sart.must-ipra.com


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: row count with libpq driver
Следующее
От: "Scot Loach"
Дата:
Сообщение: [PATCH] fix for wrong error code returned