Hi, I import a CSV file into MySQL using LOAD DATA INFILE. That's no problem. The problem is the textfile contains German umlauts. When I query the table with MySQL-program on the console (SQL monitor) it even works fine. But when I output in PHP it only shows the correct characters if I send header header("Content-type: text/html; charset=IBM850"); I don't want to use charset IBM850 but ISO-8859-1. How to convert the umlauts. Why are they different in both charsets? Best regards Bernhard Doebler --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php