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

Re: ODBC and encodings problem

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Ben Trewern" <bendottrewern(at)mowlem(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC and encodings problem
Date: 2005-04-15 06:19:09
Message-ID: 6C0CF58A187DA5479245E0830AF84F4214321E@poweredge.attiksystem.ch (view raw or flat)
Thread:
Lists: 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(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



Responses

pgsql-odbc by date

Next:From: Florian RieffelDate: 2005-04-15 09:16:00
Subject: LF <-> CR/LF conversion
Previous:From: Ben TrewernDate: 2005-04-14 19:36:09
Subject: Re: MS Access & ODBC driver & Postgresql 8.01

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