Date |Fri, 3 Aug 2001 08:40:35 +0200
From |"Bernhard Doebler" <programmer@stripped>
Hello!
BD> Hi,
BD> 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.
BD> But when I output in PHP it only shows the correct characters if I send header
BD> header("Content-type: text/html; charset=IBM850");
BD> I don't want to use charset IBM850 but ISO-8859-1. How to convert the umlauts. Why
> are they different in both charsets?
BD> Best regards
BD> Bernhard Doebler
You can convert string from one charset to other by iconv* functions
in PHP.
http://www.php.net/manual/en/ref.iconv.php
___________________________________________________________________
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Grigory Bakunov <black@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
