|There's more than one way to do things|
Re^3: Writing International Phonetic Alphabet symbols to Excel?by rdfield (Priest)
|on Nov 20, 2009 at 15:45 UTC ( #808460=note: print w/replies, xml )||Need Help??|
After doing some testing on this, it looks like MS uses latin1 (or something very close) internally.
I used a slightly modified version of the example script from Spreadsheet::ParseExcel, replacing the "print" with a database insert.When processing some data from a spreadsheet into a PostgreSQL database, cells with symbols such as 0xae (ascii 92, the "registered" symbol, ®), I constantly came up against the database error:
After setting the client encoding to latin1 (keeping the database at UTF8):
the data went in OK.
If there is a different/better way to process this, I'd be interested to know.Update: there is a better way...
In Section Seekers of Perl Wisdom