Re: ODBC and encodings problem - Mailing list pgsql-odbc

From Philippe Lang
Subject Re: ODBC and encodings problem
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F4214321E@poweredge.attiksystem.ch
Whole thread Raw
In response to ODBC and encodings problem  ("Ben Trewern" <ben.trewern@mowlem.com>)
List pgsql-odbc
Hi,

I don't know exactly which encoding you need, but at least for french, encoding a datatabase in LATIN1 solves the
problem...

Bye

Philippe

-----Message d'origine-----
De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Ben Trewern
Envoyé : jeudi, 14. avril 2005 21:20
À : pgsql-odbc@postgresql.org
Objet : [ODBC] ODBC and encodings problem

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
hadno 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
sideor client side. 

Any ideas how to fix this?

Regards,

Ben



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



pgsql-odbc by date:

Previous
From: "Ben Trewern"
Date:
Subject: Re: MS Access & ODBC driver & Postgresql 8.01
Next
From: "Ben Trewern"
Date:
Subject: Re: ODBC and encodings problem