mysql编码问题

扫码查看
本文介绍了mysql编码问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

当我用外语向数据库中插入内容时,我遇到了问题.我已经将数据库的排序规则设置为utf8_general_ci(也尝试utf8_unicod_ci).但是当我在表格中插入一些文本时,它就这样保存

i have a proble, when insert something in foreign language into database.i have set the collation of database to utf8_general_ci(try utf8_unicod_ci too).but when i insert some text into table, it was saved like this

但是当我从数据库中读取时,文本以正确的形式显示.看起来只在数据库中一样.

but when i read from database, text shows in correct form. it looks like that only in database.

我已将html文档中的编码设置为charset = UTF-8

i have set encoding in my html document to charset=UTF-8

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

我设置了

mysql_query("SET NAMES UTF-8");
mysql_query("SET CHARACTER SET UTF-8");

当连接到数据库时.所以我认为我已经完成了所有操作,但仍以该已知格式保存.你可以帮帮我吗.预先感谢

when conecting to database.so i think that i' ve done everything, but it still save in that anknown format.could you help me.thanks in advance

推荐答案

我相信您必须在MySQL中使用SET NAMES utf8而不是UTF-8.

I believe you have to SET NAMES utf8, instead of UTF-8, in MySQL.

这篇关于mysql编码问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-29 22:49
查看更多