Re: ODBC and encodings problem

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