Unix Technical Forum

Re: problems accessing utf8 encoded databases

This is a discussion on Re: problems accessing utf8 encoded databases within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> Thanks for the responses. I have downloaded the new driver & will ask IT to install. >X-Spam-Level: >X-Spam-Status: No, ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces odbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 05:24 PM
Mija Lee
 
Posts: n/a
Default 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" <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



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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:57 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com