Flyspray:: poMMo:

FS#175 — Problem importing CSV files with iso8859-15 encoding

Attached to Project— poMMo
Opened by Claudio Vicari (cvicari) - Friday, 20 July 2007, 12:50PM

Task Type	Feature Request
Category	Subscribers
Status	Assigned
Assigned To	Brice Burgess
Operating System	All

Severity	High
Priority	Normal
Reported Version	Aardvark PR15
Due in Version	Undecided
Due Date	Undecided
Percent Complete

Details When importing csv files encoded with iso8859-15, accented characters from imported fields are displayed uncorrectly both in the preview phase and in the subscribers list.
The problem is solved if I convert the files to "UTF-8". It would be very useful to have something to detect/select the encoding.
I tried this with PHP4.4, Apache/2.2.3, mysql 5.0.24a, Mozilla Firefox 2.0.0.4

This task depends upon

This task blocks these from closing

Comments (2)
Related Tasks (0/0)

Comment by Brice Burgess (brice) - Monday, 30 July 2007, 12:32AM

I'd like to fix this problem in a future release. For reference could you attach a .CSV file containing iso8859-15 encoded characters? I'd like to use this to test my routines. Also, what is the collation of the poMMo mySQL tables? (identified via phpMyAdmin, etc.).

Thanks,

~ Brice

Comment by Claudio Vicari (cvicari) - Wednesday, 01 August 2007, 08:49AM

Thank you very much for your answer! As of your request, I'm attaching an ISO8859-15 csv file, very simple, with only two fields. My database collation is latin1_swedish_ci, maybe this is weird...

is08859-15_sample.csv