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



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: problems accessing utf8 encoded databases

Hi.

----- Original Message -----
From: "Mija Lee"

> 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


---------------------------(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

Re: problems accessing utf8 encoded databases

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"
>To: "Mija Lee" ,
>Subject: Re: [ODBC] problems accessing utf8 encoded databases
>Date: Thu, 27 Sep 2007 10:08:33 +0900
>
>Hi.
>
>----- Original Message -----
>From: "Mija Lee"
>
>> 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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: problems accessing utf8 encoded databases

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
>To: Mija Lee
>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?
>
>
>Rainer


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings