Mysqlå¨é»è®¤æ åµä¸å»ºç«è¡¨çå符ç¼ç æ¯latin1ï¼æ以å¨æå ¥ä¸ææ¶ä¼åºéã
egï¼
1ãæ¥ç表建ç«çsqlæºç ï¼
2:
3: ç»æï¼
4: CREATE TABLE `users` (
5: `userID` int(10) unsigned NOT NULL AUTO_INCREMENT,
6: `userName` varchar(45) NOT NULL,
7: `password` varchar(45) NOT NULL,
8: PRIMARY KEY (`userID`)
9: ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1
2ãæ¥ç表ä¸ååçå±æ§ï¼
å½ä»¤ï¼show full columns from users
ç»æï¼
java开发中Mysql中文乱码问题的解决
å
¶ä¸Collationå表示å符ç¼ç ã
解å³æ¹æ³ï¼
ä¸ãä¿®æ¹mysqlçé ç½®æ件ï¼
     å¨mysqlçå®è£ ç®å½ï¼C:/Program Files/MySQL/MySQL Server 5.1ï¼ä¸ï¼ä¿®æ¹my.iniã
     æ¥æ¾default-character-setå±æ§ï¼å°ä¸¤å¤é½æ¹ä¸ºGBKã以åå建表æ¶å°é»è®¤ä¸ºGBKç¼ç æ¹å¼ã
     éè¦éæ°å¯å¨mysqlæå¡ã
äºãä¿®æ¹è¡¨çå符ç¼ç å±æ§ï¼
     å½ä»¤ï¼alter table users CONVERT TO CHARACTER SET gbk
     å½ä»¤è¿è¡åï¼è¡¨çå±æ§CHARSET=GBKï¼userNameåPasswordåçCollationå±æ§å为gbk_chinese_ciã
    Â
ä¸ãä¿®æ¹servletä¸ç代ç ï¼
     å¨servletè·åä¼ è¿æ¥çåæ°ä¹å设置ç¼ç æ¹å¼ï¼å¦:
       request.setCharacterEncoding("gbk");
       String msgTitle = request.getParameter("msgTitle");
       String msgContent = request.getParameter("msgContent");
Â