Mysql中文乱码问题(unbutu)

来源：互联网发布：在线答题的软件编辑：程序博客网时间：2024/05/10 07:07

1.首先查看数据库里面的各种编码格式

mysql> show variables like "%char%";+--------------------------+---------------+| Variable_name | Value |+--------------------------+---------------+| character_set_client | gbk || character_set_connection | gbk || character_set_database | utf8 || character_set_filesystem | binary || character_set_results | gbk || character_set_server | utf8 || character_set_system | utf8 |+--------------------------+-------------+

2.除了character_set_filesystem 以外，所有的编码格式统一用UTF8进行设置

SET character_set_client='utf8';

3.同时修改web.config里面的配置文件在后面加上:CharSet=utf8

 <add name="dryunEntities" connectionString="metadata=res://*/BaseModel.csdl|res://*/BaseModel.ssdl|res://*/BaseModel.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=192.168.6.81;user id=root;password=123456;persistsecurityinfo=True;database=dryun;CharSet=utf8&quot;" providerName="System.Data.EntityClient" /></connectionStrings>

0 0