Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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 



pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group