Re: client encoding mismatch

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
>