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 по дате отправления: