List:General Discussion« Previous MessageNext Message »
From:Bernhard Doebler Date:August 3 2001 6:40am
Subject:MySQL and CharSets
View as plain text  
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

Thread
MySQL and CharSetsBernhard Doebler3 Aug
  • Re: MySQL and CharSetsWerner Stuerenburg3 Aug
  • Re: MySQL and CharSetsBernhard Doebler3 Aug
  • Re: MySQL and CharSetsGrigory Bakunov4 Aug