ODBC and encodings problem

From: "Ben Trewern" <ben(dot)trewern(at)mowlem(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC and encodings problem
Date: 2005-04-14 19:20:20
Message-ID: d3mfk8$18tq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Browse pgsql-odbc by date

  From Date Subject
Next Message Ben Trewern 2005-04-14 19:36:09 Re: MS Access & ODBC driver & Postgresql 8.01
Previous Message Nagesh Paladugu 2005-04-14 18:16:14 ODBC compilation error