Weird encoding behavior

From: "Leonardo M(dot) Ramé" <martinrame(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Weird encoding behavior
Date: 2009-03-25 18:52:55
Message-ID: gqdud7$2l60$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I'm experiencing a weird behavior when storing latin characters to a
PostgreSQL 8.3.1.876 server. The database is Latin1 encoded, and it is
working since September 2008, it wasn't updated nor replaced since its
first installation.

The weirdness of the problem is that sometimes the characters are stored
correctly, but sometimes doesn't (allways by the same program), the
field type is Varchar(30), and for example the text "NUÑEZ" is stored as
"NU?EZ".

The data comes from an external application in an XML file (also
Latin1), then, a Delphi service parses the XML and create the
Insert/Update statements to store the data in the database. I'd try to
reproduce the bug by sending XML files with 'Ñ' to the service, but it
is stored correctly.

Also, there's a front end that allows users to see/edit the data in a
user friendlier way. Again, I checked by inserting records with 'Ñ'
using this front-end, and also are stored correctly.

Does anyone faced the same problem? any workaround?

Thanks in advance,
Leonardo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-03-25 18:53:06 Re: Profiling custom datatypes
Previous Message Sam Mason 2009-03-25 18:03:56 Re: MAX(ROW(...)) - feature request