本文介绍了MySQL数据库的编码设置方法，包括查看当前编码及如何修改。此外还讲解了ASP.NET应用程序中如何设置页面编码，确保与数据库编码一致，以避免字符集不匹配导致的数据乱码问题。
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" />
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
