我的csv文件包含特殊的字符,如‘i’,‘节’等。当我读取和打印该文件时,文件中的特殊字符被转换为'�‘。我尝试将页面编码设置为UTF-8和ISO 8859-1。但这些都没有帮助。
smb能否为解决方案提供建议?
发布于 2013-10-26 12:11:10
我认为你必须检测并更改原始编码,如下所示(如果你使用php):
<?php
header( "Content-Type: text/html; charset=utf-8");
$csvContent = file_get_contents( $fileName );
$encoding = mb_detect_encoding( $csvContent,
array("UTF-8","UTF-32","UTF-32BE","UTF-32LE","UTF-16","UTF-16BE","UTF-16LE"),
TRUE );
if( $fileEncoding !== "UTF-8" ) {
$csvContent = mb_convert_encoding($csvContent, "UTF-8", $fileEncoding );
}
foreach( explode( PHP_EOL, $csvContent ) as $item ) {
var_dump($item );
}
?>
https://stackoverflow.com/questions/16231635
复制