PHPMyAdmin不导入unicode [英] PHPMyAdmin doesn't import unicode

问题描述

当我使用PHPMyAdmin的导入功能时，它不会导入非ASCII字符，例如ä，ö，ü，õ和其余字符.

当我用记事本打开CSV文件时，它会正常显示非ASCII字符，但是当我尝试导入它时-它不起作用.

手动输入那些丢失的字符是可行的，MySQL会按原样保存它们.有什么想法吗?

解决方案

当在当前字符集下遇到无效字符时，mySQL将执行此操作.

您没有提到要使用什么工具来导入数据，但是您应该能够在导入时指定字符集.如果该字符集与数据库的字符集匹配，则一切正常.另外，请确保文件实际上是使用该字符集编码的.

如果导入工具不提供选择字符集的选项，则可以尝试 phpMyAdmin 这样做.

When I use the import feature of PHPMyAdmin, it doesn't import non-ASCII characters such as ä, ö, ü, õ and the rest of the word after the characters.

When I open the CSV file with Notepad it displays the non-ASCII characters normally, but when I'm trying to import it - it doesn't work.

Entering those missing characters manually works and MySQL saves them just as it should. Any thoughts?

解决方案

mySQL will do this when it encounters a character that is invalid under the current character set.

You're not mentioning what tool you are using to import the data, but you should be able to specify a character set when importing. If that character set matches the database's, everything will be fine. Also, make sure the file is actually encoded in that character set.

If your import tool doesn't offer the option of selecting the character set, you could try phpMyAdmin which does.

这篇关于PHPMyAdmin不导入unicode的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！