From: | "Andrus" <eetasoft(at)online(dot)ee> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | 08.00.0102 with UTF8 database causes client encoding mismatch error |
Date: | 2005-11-09 17:17:11 |
Message-ID: | dktb0r$85d$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Trying to use previous version of driver with Postgres 8.1 UTF8 database
causes error
client encoding mismatch
Any idea how to fix this ?
I need to check whether one particular problem is caused by new ODBC driver
or not.
Andrus.
conn=30160408, PGAPI_DriverConnect(
in)='DRIVER={PostgreSQL};UID=postgres;PWD=x;DATABASE=eeva;SERVER=localhost;PORT=5432;B9=0;',
fDriverCompletion=1
Global Options: Version='08.00.0102', 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='OTHER'
conn=30160408, query=' '
conn=30160408, query='select version()'
[ fetched 1 rows ]
[ PostgreSQL version string = 'PostgreSQL 8.1.0 on i686-pc-mingw32,
compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)' ]
[ PostgreSQL version number = '8.1' ]
conn=30160408, query='set DateStyle to 'ISO''
conn=30160408, query='set geqo to 'OFF''
conn=30160408, query='set extra_float_digits to 2'
conn=30160408, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=30160408, query='select pg_client_encoding()'
[ fetched 1 rows ]
[ Client encoding = 'UTF8' (code = 34) ]
Client encoding = 'UTF8' and OTHER
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=214, errmsg='client encoding mismatch'
------------------------------------------------------------
henv=30160352, conn=30160408, status=0, num_stmts=16
sock=30171424, stmts=30187896, lobj_type=-999
---------------- Socket Info -------------------------------
socket=460, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=30171496, buffer_out=30179696
buffer_filled_in=58, buffer_filled_out=0, buffer_read_in=58
From | Date | Subject | |
---|---|---|---|
Next Message | P.M | 2005-11-09 17:58:54 | Re: Anyone using PostgresODBC and .NET 2.0? |
Previous Message | Claus Scherschel | 2005-11-09 16:57:26 | Selecting schemas in ODBC/Win32 |