如题所述
对äºMySQLæ°æ®åºçä¹±ç é®é¢ï¼æ两ä¸æ
åµï¼
1. mysqlæ°æ®åºç¼ç é®é¢ï¼å»ºåºæ¶è®¾å®ï¼ã
2. è¿æ¥mysqlæ°æ®åºçurlç¼ç 设置é®é¢ã
对äºç¬¬ä¸ä¸ªé®é¢ï¼ç®å个人åç°åªè½éè¿éæ°å»ºåºè§£å³ï¼å»ºåºçæ¶åï¼éæ©UTF-8å符éãæè¯è¿ä¿®æ¹ç°ææ°æ®åºå符é为UFT
-8ï¼ä½æ¯æ ¹æ¬ä¸èµ·ä½ç¨ï¼æå ¥çä¸æä»ç¶ä¹±ç ï¼ä¸ææ¾ç¤ºæï¼???ï¼ãé建åºæ¶éæ©å符é为UTF-8ä¹åï¼ä¸ææ£å¸¸æ¾ç¤ºäºã
对äºç¬¬äºä¸ªé®é¢ï¼æ¯è¿æ ·çæ åµï¼æ建åºæ¶è®¾ç½®äºæ°æ®åºé»è®¤å符é为UTF-8ï¼éè¿mysql workbenchç´æ¥æå ¥ä¸ææ¾ç¤ºå®å ¨æ£å¸¸ãä½æ¯ä½¿ç¨mybaitsæå ¥æ°æ®æ¶ï¼ä¸ææ¾ç¤ºæäº"???"è¿æ ·çä¹±ç ãä½ä»æ°æ®åºè·åçä¸æä¸ä¼ä¹±ç ãè·è¸ªæ°æ®åºæä½ï¼SQLè¯å¥ä¸çä¸æè¿æ¯æ¾ç¤ºæ£å¸¸çï¼ä½æ¯æå ¥å°mysqlæ°æ®åºå就乱ç äºï¼äºæ¯å¤æå¯è½æ¯æ°æ®åºè¿æ¥çé®é¢ãåæ¥å¨ç½ä¸æ¾äºä¸èµæï¼åç°ç¡®å®å¯ä»¥ä¸ºmysqlæ°æ®åºçè¿æ¥å符串设置ç¼ç æ¹å¼ï¼å¦ä¸ï¼
jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
æ·»å äºuseUnicode=true&characterEncoding=utf8åæ°ä¹åï¼æå ¥ä¸æå°±æ£å¸¸äºã
æ·»å çä½ç¨æ¯ï¼æå®å符çç¼ç ã解ç æ ¼å¼ã
ä¾å¦ï¼å设mysqlæ°æ®åºç¨çæ¯GBKç¼ç ï¼ä¹å¯è½æ¯å ¶å®ï¼ä¾å¦Ubuntuä¸å°±æ¯latin1ï¼ï¼è项ç®æ°æ®åºç¨çæ¯utf-8ç¼ç ãè¿æ¶åå¦ææ·»å äºuseUnicode=true&characterEncoding=UTF-8 ï¼é£ä¹ä½ç¨æå¦ä¸ä¸¤ä¸ªæ¹é¢ï¼
1. åæ°æ®æ¶ï¼
æ°æ®åºå¨åæ¾é¡¹ç®æ°æ®çæ¶åä¼å ç¨UTF-8æ ¼å¼å°æ°æ®è§£ç æåèç ï¼ç¶ååå°è§£ç åçåèç éæ°ä½¿ç¨GBKç¼ç åæ¾å°æ°æ®åºä¸ã
2.åæ°æ®æ¶ï¼
å¨ä»æ°æ®åºä¸åæ°æ®çæ¶åï¼æ°æ®åºä¼å å°æ°æ®åºä¸çæ°æ®æGBKæ ¼å¼è§£ç æåèç ï¼ç¶ååå°è§£ç åçåèç éæ°æUTF-8æ ¼å¼ç¼ç æ°æ®ï¼æååå°æ°æ®è¿åç»å®¢æ·ç«¯ã追é®
1. mysqlæ°æ®åºç¼ç é®é¢ï¼å»ºåºæ¶è®¾å®ï¼ã
2. è¿æ¥mysqlæ°æ®åºçurlç¼ç 设置é®é¢ã
对äºç¬¬ä¸ä¸ªé®é¢ï¼ç®å个人åç°åªè½éè¿éæ°å»ºåºè§£å³ï¼å»ºåºçæ¶åï¼éæ©UTF-8å符éãæè¯è¿ä¿®æ¹ç°ææ°æ®åºå符é为UFT
-8ï¼ä½æ¯æ ¹æ¬ä¸èµ·ä½ç¨ï¼æå ¥çä¸æä»ç¶ä¹±ç ï¼ä¸ææ¾ç¤ºæï¼???ï¼ãé建åºæ¶éæ©å符é为UTF-8ä¹åï¼ä¸ææ£å¸¸æ¾ç¤ºäºã
对äºç¬¬äºä¸ªé®é¢ï¼æ¯è¿æ ·çæ åµï¼æ建åºæ¶è®¾ç½®äºæ°æ®åºé»è®¤å符é为UTF-8ï¼éè¿mysql workbenchç´æ¥æå ¥ä¸ææ¾ç¤ºå®å ¨æ£å¸¸ãä½æ¯ä½¿ç¨mybaitsæå ¥æ°æ®æ¶ï¼ä¸ææ¾ç¤ºæäº"???"è¿æ ·çä¹±ç ãä½ä»æ°æ®åºè·åçä¸æä¸ä¼ä¹±ç ãè·è¸ªæ°æ®åºæä½ï¼SQLè¯å¥ä¸çä¸æè¿æ¯æ¾ç¤ºæ£å¸¸çï¼ä½æ¯æå ¥å°mysqlæ°æ®åºå就乱ç äºï¼äºæ¯å¤æå¯è½æ¯æ°æ®åºè¿æ¥çé®é¢ãåæ¥å¨ç½ä¸æ¾äºä¸èµæï¼åç°ç¡®å®å¯ä»¥ä¸ºmysqlæ°æ®åºçè¿æ¥å符串设置ç¼ç æ¹å¼ï¼å¦ä¸ï¼
jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
æ·»å äºuseUnicode=true&characterEncoding=utf8åæ°ä¹åï¼æå ¥ä¸æå°±æ£å¸¸äºã
æ·»å çä½ç¨æ¯ï¼æå®å符çç¼ç ã解ç æ ¼å¼ã
ä¾å¦ï¼å设mysqlæ°æ®åºç¨çæ¯GBKç¼ç ï¼ä¹å¯è½æ¯å ¶å®ï¼ä¾å¦Ubuntuä¸å°±æ¯latin1ï¼ï¼è项ç®æ°æ®åºç¨çæ¯utf-8ç¼ç ãè¿æ¶åå¦ææ·»å äºuseUnicode=true&characterEncoding=UTF-8 ï¼é£ä¹ä½ç¨æå¦ä¸ä¸¤ä¸ªæ¹é¢ï¼
1. åæ°æ®æ¶ï¼
æ°æ®åºå¨åæ¾é¡¹ç®æ°æ®çæ¶åä¼å ç¨UTF-8æ ¼å¼å°æ°æ®è§£ç æåèç ï¼ç¶ååå°è§£ç åçåèç éæ°ä½¿ç¨GBKç¼ç åæ¾å°æ°æ®åºä¸ã
2.åæ°æ®æ¶ï¼
å¨ä»æ°æ®åºä¸åæ°æ®çæ¶åï¼æ°æ®åºä¼å å°æ°æ®åºä¸çæ°æ®æGBKæ ¼å¼è§£ç æåèç ï¼ç¶ååå°è§£ç åçåèç éæ°æUTF-8æ ¼å¼ç¼ç æ°æ®ï¼æååå°æ°æ®è¿åç»å®¢æ·ç«¯ã追é®
æé½æ·»å äºï¼é½æ²¡ç¨ï¼æåªæ¯æ´æ°æ°æ®åºé®é¢
温馨提示:答案为网友推荐,仅供参考