I've just tried converting my "normal" csv (produced by MS Excel when saving an xls just as ordinary csv) into csv UTF-8 using the "Convert to UTF-8" feature of Notepad++ as explained here:
How to convert csv files encoding to utf-8
One problem is that the british pound sign (£), which is originally encoded in my csv as A3, got converted into D088 and so is showing up as "J" now. The following link tells me that it should be C2A3 instead and manually changing D088 to C2A3 fixes it indeed:
http://unicode.org/mail-arch/unicode-ml/y2009-m06/0069.html
Is it a Notepad++ issue by chance? Is there perhaps any other way of converting it properly, so there's no need to fix anything like that afterwards? My MS Excel has no "Save as csv UTF-8" option.
Many thanks in advance!
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…