Weird encoding behavior

Поиск
Список
Период
Сортировка
Искать
От
Leonardo M. Ramé
Тема
Weird encoding behavior
Дата
Msg-id
gqdud7$2l60$1@news.hub.org
Список
Дерево обсуждения
Weird encoding behavior "Leonardo M. Ramé" <martinrame@yahoo.com>
Re: Weird encoding behavior Alvaro Herrera <alvherre@commandprompt.com>
Re: Weird encoding behavior Martin Gainty <mgainty@hotmail.com>
Re: Weird encoding behavior "Albe Laurenz" <laurenz.albe@wien.gv.at>
Re: Weird encoding behavior "Leonardo M. Ramé" <martinrame@yahoo.com>
Re: Weird encoding behavior "Albe Laurenz" <laurenz.albe@wien.gv.at>
Re: Weird encoding behavior Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-general по дате отправления
От: ries van Twisk
Дата:
От: Scott Marlowe
Дата:
Сообщение: Re: Parallel Query Processing
FAQ