数据库是utf8格式 有个字段是msg ,格式也是utf8 我从数据库里读取时数据库连接串中string connectstring = "Uid=Cgoods;Server=192.168.1.1;Database=dbGood;Pwd=123456;Port=8888;character set=utf8;";
也加入了
character set=utf8 但我读取时仍然是乱码,以下是调试时的界面
该如何解决呢
也加入了
character set=utf8 但我读取时仍然是乱码,以下是调试时的界面
该如何解决呢
server=10.7.70.132;uid=admin;pwd=admin;database=ce_manage_db; pooling=false;charset=utf8";
如果是繁體系統,什麼問題都有可能會出現。
mysql> show variables like 'cha%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |