Thread: problems accessing utf8 encoded databases
Hi: I'm new to this list and to postgres, so hopefully this won't sound like a stupid question. We are trying to connect from sas 9.13 service pack 3 to a postgres database version 8.2.4. We are able to do so without any problems when the databases are sql-ascii encoded, but get ERROR: CLI error trying to establish connection: [unixODBC]client encoding mismatch I'm able to connect to the same server, different databases that are not UTF-8 encoded. I have UNICODE=UTF8 as a line in the odbc.ini. We are calling the sas9 program with a utf-8 encoding option. T We are using 8.00.0100, but from what I've read it looks like utf-8 support started in version 7.1. I didn't install the driver myself, but is there something special I need to do to get utf-8 working with the odbc driver? Mija
Hi. ----- Original Message ----- From: "Mija Lee" <mija@scharp.org> > Hi: > > I'm new to this list and to postgres, so hopefully this won't sound like a > stupid question. We are trying to connect from sas 9.13 service pack 3 to a > postgres database version 8.2.4. We are able to do so without any problems when > the databases are sql-ascii encoded, but get > > ERROR: CLI error trying to establish connection: [unixODBC]client encoding > mismatch > > I'm able to connect to the same server, different databases that are not UTF-8 > encoded. I have UNICODE=UTF8 as a line in the odbc.ini. We are calling the sas9 > program with a utf-8 encoding option. T > > We are using 8.00.0100, but from what I've read it looks like utf-8 support > started in version 7.1. I didn't install the driver myself, but is there > something special I need to do to get utf-8 working with the odbc driver? > > Mija Um, Although the version of the driver with which you use me may have a problem, it thinks that support is difficult....Would you use our new driver, supposing it is possible? It does not reproduce your problem. http://winpg.jp/~saito/psqlODBC/psqlODBC_use_ASCII.png We were preparing the now newest release. It is Version 08.02.0500. please see, http://www.postgresql.org/ftp/odbc/versions/ Sorry, the newest official announcement was preparing us... Regards, Hiroshi Saito
Thanks for the responses. I have downloaded the new driver & will ask IT to install. >X-Spam-Level: >X-Spam-Status: No, score=-3.0 required=5.0 tests=WL_SAS autolearn=ham version=3.1.3 >From: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp> >To: "Mija Lee" <mija@scharp.org>, <pgsql-odbc@postgresql.org> >Subject: Re: [ODBC] problems accessing utf8 encoded databases >Date: Thu, 27 Sep 2007 10:08:33 +0900 > >Hi. > >----- Original Message ----- >From: "Mija Lee" <mija@scharp.org> > >> Hi: >> >> I'm new to this list and to postgres, so hopefully this won't sound like a >> stupid question. We are trying to connect from sas 9.13 service pack 3 to a >> postgres database version 8.2.4. We are able to do so without any problems when >> the databases are sql-ascii encoded, but get >> >> ERROR: CLI error trying to establish connection: [unixODBC]client encoding >> mismatch >> >> I'm able to connect to the same server, different databases that are not UTF-8 >> encoded. I have UNICODE=UTF8 as a line in the odbc.ini. We are calling the sas9 >> program with a utf-8 encoding option. T >> >> We are using 8.00.0100, but from what I've read it looks like utf-8 support >> started in version 7.1. I didn't install the driver myself, but is there >> something special I need to do to get utf-8 working with the odbc driver? >> >> Mija > >Um, Although the version of the driver with which you use me may have a problem, >it thinks that support is difficult....Would you use our new driver, supposing it is >possible? >It does not reproduce your problem. >http://winpg.jp/~saito/psqlODBC/psqlODBC_use_ASCII.png > >We were preparing the now newest release. It is Version 08.02.0500. please see, >http://www.postgresql.org/ftp/odbc/versions/ > >Sorry, the newest official announcement was preparing us... > >Regards, >Hiroshi Saito
Good news, the latest drivers resolved this problem... Thanks for the help. >X-Spam-Level: >X-Spam-Status: No, score=0.0 required=5.0 tests=none autolearn=ham version=3.1.3 >Date: Wed, 26 Sep 2007 22:34:21 +0200 >From: Rainer Bauer <usenet@munnin.com> >To: Mija Lee <mija@scharp.org> >Subject: Re: [ODBC] problems accessing utf8 encoded databases > >Hello Mija, > >Wednesday, September 26, 2007, 10:13:57 PM, you wrote: > >ML> We are using 8.00.0100, but from what I've read it looks like utf-8 support >ML> started in version 7.1. I didn't install the driver myself, but is there >ML> something special I need to do to get utf-8 working with the odbc driver? > >seems there have been problems with the old driver. What happens if >you use the 8.02.0400 driver that fits your Postgres version? ><http://www.postgresql.org/ftp/odbc/versions/> > >Rainer