Re: client encoding mismatch - Mailing list pgsql-odbc

From Hiroshi Saito
Subject Re: client encoding mismatch
Date
Msg-id 06d501c5bdaf$a9748780$01324d80@hiroshi5jz7dqj
Whole thread Raw
In response to client encoding mismatch  (Andrey Repko <repko@sart.must-ipra.com>)
List pgsql-odbc
Hi Andrey.

This may not be good management. However, Some problems will be solved.
This is correspondence only by the Multibyte. I desire proper evaluation by Dave.

Regards,
Hiroshi Saito

From: "Andrey Repko"


> 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='xx
xxx'
>           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
>

Attachment

pgsql-odbc by date:

Previous
From: Andrey Repko
Date:
Subject: client encoding mismatch
Next
From: "Dave Page"
Date:
Subject: Re: client encoding mismatch