|
Hola use Ñ for spanish N http://webdesign.about.com/od/localization/l/blhtmlcodes-sp.htm Saludos Cordiales desde EEUU! Martin ______________________________________________ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inform the sender. Any unauthorised dissemination or copying hereof is prohibited. This message serves for information purposes only and shall not have any legally binding effect. Given that e-mails can easily be subject to manipulation, we can not accept any liability for the content provided. > From: martinrame@xxxxxxxxx > Subject: Weird encoding behavior > Date: Wed, 25 Mar 2009 15:52:55 -0300 > To: pgsql-general@xxxxxxxxxxxxxx > > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Internet Explorer 8 – Now Available. Faster, safer, easier. Download FREE now! |
