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(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Ben Trewern
Envoyé : jeudi, 14. avril 2005 21:20
À : pgsql-odbc(at)postgresql(dot)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 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

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