|
|
Choosing A Webhost: |
client encoding mismatch: msg#00160db.postgresql.odbc
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='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 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 -- С наилучшими пожеланиями, Репко Андрей Владимирович mailto:repko@xxxxxxxxxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Problema with Varchar on version 8x of ODBC Driver, Cleber Nardelli |
|---|---|
| Next by Date: | Re: client encoding mismatch, Hiroshi Saito |
| Previous by Thread: | client encoding mismatch, Andrey Repko |
| Next by Thread: | Re: client encoding mismatch, Hiroshi Saito |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |