我在使用PHP将ISO-8859-1编码的数据库内容转换为UTF-8时遇到了一些问题。我运行以下代码进行测试:
// Connect to a latin1 charset database
// and retrieve "Georgia O’Keeffe", which contains a "’" character
$connection = mysql_connect('*****', '*****', '*****');
mysql_select_db('*****', $connection);
mysql_set_charset('latin1', $connection);
$result = mysql_query('SELECT notes FROM categories WHERE id = 16', $connection);
$latin1Str = mysql_result($result, 0);
$latin1Str = substr($latin1Str, strpos($latin1Str, 'Georgia'), 16);
// Try to convert it to UTF-8
$utf8Str = iconv('ISO-8859-1', 'UTF-8', $latin1Str);
// Output both
var_dump($latin1Str);
var_dump($utf8Str);
当我在Firefox的源视图中运行此代码时,确保Firefox的编码设置为“Western (ISO-8859-1)”,我会得到以下结果:
当我将Firefox的编码设置更改为“UTF-8”后,结果如下:
iconv()
不应该将其转换为UTF-8吗?