Re: ODBC Driver stability - Mailing list pgsql-odbc

From Benjamin Riefenstahl
Subject Re: ODBC Driver stability
Date
Msg-id m3ekiwtqf4.fsf@seneca.benny.turtle-trading.net
Whole thread Raw
In response to Re: ODBC Driver stability  (Jaime Casanova <systemguards@yahoo.com>)
List pgsql-odbc
Hi Jaime,


Jaime Casanova writes:
> Just for me to understand this right. when i use vb with the odbc i
> got these changes in non-ASCII characters but NO when using EMS
> pgmanager nor when selecting directly from psql.

Probably the ODBC driver tries to convert from the database encoding
to the system encoding of MS Windows.  The translation loses for
characters that are not defined in SQL_ASCII.

Applications that use a different PostgreSQL client library may use
other encoding conversion routines or no conversion at all.  But
that's probably just luck and may change with the next version of
those tools.

>Benjamin Riefenstahl escribió:
>> Because there are no Spanish characters in ASCII (ASCII is a 7 bit
>> encoding), a database in SQL_ASCII may do anything with those
>> characters.

To be accurate here, replace "a database" with "any module that is
involved on the way from the database to the display and back again."


benny


pgsql-odbc by date:

Previous
From: "Markus Donath"
Date:
Subject: Re: ODBC Driver stability
Next
From: M.Feldtmann@t-online.de (Marten Feldtmann)
Date:
Subject: IBM VisualAge Smalltalk, ODBC, 8.0 Beta 4 and retrieving results with attribute values = NULL