Importing *.csv with special characters

[avs-code]

v7.0.0-180920-61c7a3
When a csv with special characters (ñ á é í ó) are imported, data isn't being imported correctly:

*.csv uft8 - mysql uft8_unicode_ci

Importing:
icao,iata,name,location,country,timezone,hub,lat,lon,ground_handling_cost,fuel_100ll_cost,fuel_jeta_cost,fuel_mogas_cost
LEMD,MAD,"Adolfo Suárez Madrid?Barajas Airport",Madrid,Spain,Europe/Madrid,1,40.4719,-3.5626,,4.42,4,
Result in:
icao,iata,name,location,country,timezone,hub,lat,lon,ground_handling_cost,fuel_100ll_cost,fuel_jeta_cost,fuel_mogas_cost
"LEMD","MAD","LEMD","Adolfo Su","Madrid","Spain","Europe/Madrid","1","40.4719","-3.5626",NULL,"4.42","4.00",NULL

[nabeelio]

Is it truncating the name?

[avs-code]

Yes
I checked again, and when you export the csv from phpvms7 its in ANSI:
ICAO LEMD:

Adolfo Suárez Madrid?Barajas Airport

It may be that when reimporting it from ANSI it is truncated?

Adolfo Su

With notepad++ I select convert to UTF-8 without boom and after that I import the csv in phpvms7 admin panel and not issues, except the ? that previously was a - or similars characters that appear when exporting in ANSI.

[nabeelio]

Can you attach the CSV you're using? I can check see what's going on. I think you're onto something RE ANSI

[avs-code]

airports(exported from phpvms7).zip

[nabeelio]

Ok so I adjusted the exporter to go to utf-8. I'm not sure why I had forced it to iso. The sample file above is trashed (sorry) so you'll need to export from fresh.