将latin1转换为UTF8 [英] Convert latin1 to UTF8
问题描述
我有一个数据库-包含表中的文章.
I have a DB - with the table articles.
我想将标题和内容字段转换为utf8
现在-所有数据如下所示:פורטל רעל × ×¤×ª×— רשמית!
我希望它成为普通的希伯来语字符.
I want to convert the title, and content field to utf8
now - all data looks like this: פורטל רעל × ×¤×ª×— רשמית!
I want it to become normal hebrew characters.
谢谢
推荐答案
您可以从该数据库进行mysqldump.然后下载类似Notepad ++的文件,打开转储文件,将其转换为UTF8,然后通过文件将所有编码替换为utf-8,包括第一个SET NAMES运算符.
You can make mysqldump from this database. Then download something like Notepad++, open dump file, convert it to UTF8, then replace through the file all encodings to utf-8 including the first SET NAMES operator.
如果通过phpMyAdmin(具有默认设置)将文件转储到文件,请使用编码为ISO-8859-1的输出文件,而不是默认情况下看到的UTF-8.
If you make dump to file via phpMyAdmin (with default settings) use output file encoding ISO-8859-1 instead of UTF-8 as you can see by default.
这篇关于将latin1转换为UTF8的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!