asp.net mysql 5.0 中文乱码

mysql 编码设置:

1.查看

mysql> show variables like 'character/_set/_%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| character_set_client          | utf8  |
| character_set_connection | utf8  |
| character_set_database   | utf8  |
| character_set_results       | utf8  |
| character_set_server        | utf8  |
| character_set_system       | utf8  |
+--------------------------+-------+

 

2.编码修改

mysql>set  character_set_system  utf8;

 

asp.net 页面编码:

1.web.config

<add key="data" value="server=127.0.0.1;database=test;uid=root;pwd=123456;charset=utf8" />

2.web.config

<globalization    requestEncoding="utf-8"  responseEncoding="utf-8"

 

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