Postgres Pro
Downloads
Home   >   mailing lists

ODBC and encodings problem - Mailing list pgsql-odbc

From Ben Trewern
Subject ODBC and encodings problem
Date
Msg-id d3mfk8$18tq$1@news.hub.org
Whole thread Raw
List pgsql-odbc
Tree view 
Hi all,

Using PostgreSQL 8.0.1 on Linux

I've got a database with an encoding of SQL_ASCII.  I've accessed it with
pgAdmin III and Delphi through ZeosDBO and had no problems.  Now I've been
using MS Access XP with pgODBC version 8.00.0101 to connect to it with some
success till now.  I've noticed that any field with a � sign in it is not
displaying correctly, I get 'WO �,658.06' instead of  'WO �4,658.06' and 'WO
�60.56' instead of 'WO �128.88' etc.  I assume it's something to do with the
encodings used server side or client side.

Any ideas how to fix this?

Regards,

Ben

pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: How can I configure the postgresql odbc to return 1 row at a time?
Next
From: "Ben Trewern"
Date:
Subject: Re: MS Access & ODBC driver & Postgresql 8.01