mysqlæ°æ®ä¹±ç é®é¢å¯è½æ以ä¸ä¸ç§åå :
1.serveræ¬èº«è®¾å®é®é¢ï¼ä¾å¦è¿åçå¨latin1çæ¬;
2.tableçè¯ç³»è®¾å®é®é¢(å
å«characterä¸collation);
3.客æ·ç«¯ç¨å¼(ä¾å¦php,java)çè¿çº¿è¯ç³»è®¾å®é®é¢;
建议使ç¨utf8!!!!
æ³è¦é¿å
mysqlçä¸æä¹±ç é®é¢,å¯ä»¥å°è¯ä»¥ä¸æ¹æ³ï¼
1,对äºçæ¬é®é¢ï¼å»ºè®®å»å®ç½æ´æ°ææ°ççæ¬æè
æ¯è¾å¥½ç¨ççæ¬ï¼
2,å建æ°æ®åºï¼å建表æ¶æ²¡æ对å符ç¼ç è¿è¡è®¾å®ä¼é æä¹±ç é®é¢:
å建æ°æ®åºçæ¶åï¼CREATE DATABASE `test`
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';
建表çæ¶å CREATE TABLE `database_user` (
`ID` varchar(40) NOT NULL default '',
`UserID` varchar(40) NOT NULL default '',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3,对äºç¬¬ä¸ç§æ
åµ,åèä¸ä¸æ¹æ³:
ç¼è¾linuxæå¡å¨ä¸/etc/my.cnfæ件,å¨[mysql]段å å
¥default_character_set=utf8;
å¦æåªæ¯è°è¯éå°ä¹±ç é®é¢:
å¨ç¼åConnection URLæ¶ï¼å ä¸?useUnicode=true&characterEncoding=utf-8åæ°;
并ä¸å¨ç½é¡µä»£ç ä¸å ä¸ä¸ä¸ª"set names utf8"æè
"set names gbk"çæ令ï¼åè¯MySQLè¿çº¿å
容é½è¦ä½¿ç¨utf-8æè
gbkã
utf8æè
gbk;
温馨提示:内容为网友见解,仅供参考