åæ°æ®textå段åå ¥æ¶æ¥é :Â
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1366, "Incorrect string value: '\\xF0\\x9F\\x91\\x87</...' for column 'xmlContents' at row 8")
ä¸è¬æ¥è¯´Mysql(å°äº5.5.3)å符é设置为utf8,æå®è¿æ¥çå符éä¹ä¸ºutf8,ä½æ¯ï¼å½å符串ä¸æç¹æ®å符ï¼å¦emoji表æ 符å·ï¼ä»¥åå ¶ä»å¡æ¯è½¬æutf8è¦å ç¨4åèçå符ï¼å°±ä¼æé®é¢ä¼æ¥éÂ
éå°è¿ä¸ªé®é¢ï¼æ两ç§è§£å³æ¹å¼ï¼
- ç¨åºé转æ¢ä¸ä¸å¦emoji Utilä¹ç±»ç解å³æ¹å¼å°ç¹æ®å符æ¿æ¢æ"" 空å符串
- åº/表/å段 é½è®¾ç½®ä¸ºutf8mb
è¿æ¥æ°æ®åºä¹éè¦è®¾ç½®mysql_url = mysql+pymysql://%(user)s:%(password)s@%(host)s:%(port)s/%(database)s?charset=utf8mb
ä¿®æ¹åºçå符é
è¯æ³ï¼alter database åºå default character set å符é;
alter database test default character set utf8mb4;
ä¿®æ¹è¡¨çå符é
è¯æ³ï¼alter table 表å convert to character set å符é;
alter table test1 convert to character set utf8mb4;
ä¿®æ¹å段çå符é
è¯æ³ï¼alter table 表å modify å段å å段å±æ§ character set å符éï¼
alter table test1 modify name char(10) character set utf8mb4;