Re: psqlodbclibpq 8_1_03 unicode problem

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <jfradkin(at)wazagua(dot)com>, <Josef(dot)Springer(at)JOOPS(dot)COM>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: psqlodbclibpq 8_1_03 unicode problem
Date: 2005-08-10 13:37:00
Message-ID: 002301c59db0$a049feee$6a01a8c0@valehousing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


-----Original Message-----
From: "Joel Fradkin"<jfradkin(at)wazagua(dot)com>
Sent: 10/08/05 14:15:33
To: "'Josef Springer'"<Josef(dot)Springer(at)JOOPS(dot)COM>, "pgsql-odbc(at)postgresql(dot)org"<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [ODBC] psqlodbclibpq 8_1_03 unicode problem

> Is the database Unicode?
> When I was in SQLASCII mine read as ?
> The older driver 7.4 reas SQLASCII ok and
> presented French characters ok,
> but newer version did not.
> When I converted to a Unicode database I
> could read the French characters ok
> with the new driver.

Indeed - SQLASCII often works 'by accident', however there is no guarantee. You must use an encoding that properly supports your data. Unicode should work for most.

> By the way been up Since Monday no odbc
> errors yet :)

That’s great news :-)

/D

-----Unmodified Original Message-----
Not sure why your getting that.
Is the database Unicode?
When I was in SQLASCII mine read as ?
The older driver 7.4 reas SQLASCII ok and presented French characters ok,
but newer version did not.
When I converted to a Unicode database I could read the French characters ok
with the new driver.

By the way been up Since Monday no odbc errors yet :)

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305

jfradkin(at)wazagua(dot)com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Josef Springer
Sent: Wednesday, August 10, 2005 7:58 AM
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] psqlodbclibpq 8_1_03 unicode problem

I have the same problem and reported a bug.
It seems, that Unicode is readed unencoded (one byte per character)

Josef Springer

Simeó Reig wrote:

>> I am using the versionde psqlodbclibpq 8_01_003, to be able to use ssl
>> connections, and until the moment works well, but the problem has it
>> with
>> caracters like:
>>
>> character Ñ, show like character ?
>> character ó, show like character ??
>>
>> that I can make?
>>
>> Thank you
>
>
> I've the same problem too with spanish and catalan letters, Seems like
> it don't support unicode characters.
>
> Thanks a lot
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Browse pgsql-odbc by date

  From Date Subject
Next Message Kirk Friggstad 2005-08-10 14:58:38 Re: ODBC driver and linked server in MSSQL 2k
Previous Message Dave Page 2005-08-10 13:29:20 Re: psqlodbclibpq 8_1_03 unicode problem