I have a comma-delimited ascii file that I've imported into MySQL using XAMPP's phpmyadmin IDE that contains a number of Spanish characters. All these characters are within the 8-bit ascii set. Several of them, namely unicodes U0161: "¡", U0191: "¿", and U0241: "ñ", import as '?' All other Spanish language characters, namely the vowels with acute accents, like "á" and umlauted character "ü", import fine.
I've tried various 'character set of the import file' and per-table 'collation' options, including UTF-8, collated with utf8_spanish1_ci and utf8_spanish2_ci. I've also tried ISO-8859-1 in conjunction with collations latin1_general_ci, latin1_general_cs, and latin1_spanish_ci.
I've set intl.default_locale = "es" in php.ini There is no lang.tmp file anywhere on my computer.
Also, since the file is a comma-delimited file, I checked to see if there was any field parsing error, and could find none in sampling the 5000+ records in the file.
I understand that PHP 5 can have problems with UTF-8 (see http://www.phpwact.org/php/i18n/utf-8), but these are related to PCRE so I don't see how the import functions in myphpadmin could have anything to do with the problem in light of the fact that I didn't find any field parsing errors: surely breaking substrings at inappropriate places with regular expressions would result in nonsense in some fields.
TDinDC