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: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

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



-----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?



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


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-2017 The PostgreSQL Global Development Group