¹¤¾ßºÍ¼¼ÊõÖ§³Ö
ΪÁ˸üºÃµØÖÎÀíÏ¢Õù¾ö±àÂëÎÊÌ⣬¿ÉÒÔÀûÓÃһЩ¹¤¾ßºÍ¼¼Êõ£º
±àÂë¼ì²â¹¤¾ß£ºÈçChardet¡¢EncodingDetectorµÈ¹¤¾ß£¬¿ÉÒÔ×ÊÖú¼ì²âÎļþ»òÊý¾ÝÁ÷µÄ±àÂ뻨Ñù¡£×Ö·û´®´¦Àí¿â£ºÈçPythonÖеÄcodecs¿â£¬¿ÉÒÔÔÚ×Ö·û´®´¦ÀíÀú³ÌÖнøÐбàÂëת»»ºÍ´¦Àí¡£Êý¾Ý¿âÉèÖãºÈ·±£Êý¾Ý¿âʹÓÃUTF-8±àÂ룬²¢ÔÚ±íºÍ×Ö¶ÎÖÐÃ÷È·±àÂ뻨Ñù¡£
ͨ¹ýÒÔÉϰ취£¬Äú¿ÉÒÔÓÐЧµØÖÆÖ¹±àÂë·×ÆçÖÂÎÊÌ⣬²¢È·±£ÏîĿ˳Àû½øÐС£ÎÒÃǽ«½øÒ»²½Ì½ÌÖ¾ßÌåµÄʵÏÖÒªÁìºÍ³£¼ûµÄ½â¾ö¼Æ»®¡£
ÔÚÉÏÒ»²¿·ÖÖУ¬ÎÒÃÇÒѾÏêϸÌÖÂÛÁËÈçºÎÀí½â±àÂë·×ÆçÖÂÎÊÌâ²¢Ìá³öÁ˱Ü?ÃâÃØÂÒÂëµÄ»ù´¡°ì·¨¡£ÔÚ±¾²¿·ÖÖУ¬ÎÒÃǽ«ÉîÈë̽ÌÖ¾ßÌåµÄʵÏÖÒªÁìºÍ³£¼ûµÄ½â¾ö¼Æ»®£¬ÒÔ×ÊÖúÄúÔÚʵ¼ÊÏîÄ¿ÖÐÓ¦¶Ô±àÂëÎÊÌâ¡£
»òÕßÔÚApacheÖÐÌí¼Ó£º
AddDefaultCharsetUTF-8Êý¾Ý¿â±àÂëÈç¹ûÄúµÄÓ¦ÓóÌÐòʹÓÃÊý¾Ý¿â£¬ÇëÈ·±£Êý¾Ý¿âºÍ±íµÄ×Ö·û±àÂëÉèÖÃΪUTF-8¡£¿ÉÒÔÔÚMySQLÖÐʹÓÃÒÔÏÂÃüÁALTERDATABASEyour_databaseCHARACTERSETutf8COLLATEutf8_general_ci;ALTERTABLEyour_tableCONVERTTOCHARACTERSETutf8COLLATEutf8_general_ci;
ÐÞ¸´¡°ÑÇÖÞIVÃØÂÒÂ롱µÄÒªÁì
ͳһ×Ö·û±àÂ룺ȷ±£?ËùÓÐϵͳºÍÓ¦ÓóÌÐòʹÓÃͳһµÄ×Ö·û±àÂ뻨Ñù£¬ÖÆÖ¹Òò±àÂë·×ÆçÖµ¼?ÖµÄÂÒÂëÎÊÌâ¡£Êý¾ÝУÑ飺ÔÚÊý¾Ý´«ÊäÀú³ÌÖУ¬Ôö¼ÓУÑé»úÖÆ£¬ÈçCRCУÑ飬ȷ±£Êý¾Ý´«ÊäµÄÍêÕûÐÔºÍ׼ȷÐÔ¡£ÍøÂçÓÅ»¯£ºÓÅ»¯ÍøÂçÅäÖ㬼õÉÙÍøÂçÓµÈûºÍÊý¾Ý°üɥʧ£¬´ÓȪԴÉϽâ¾öÂÒÂëÎÊÌâ¡£
ϵͳÉý¼¶£º¸üвÙ×÷ϵͳºÍÓ¦ÓóÌÐòµ½×îа汾£¬ÐÞ¸´ÒÑÖªµÄ¼æÈÝÐÔÎÊÌâºÍ©¶´¡£
ÆäËûСÌùÊ¿
ʹÓýØÍ¼¹¤¾ß£ºÈç¹ûÂÒÂëÎÊÌâÈÔÈ»ÎÞ·¨½â¾ö£¬¿ÉÒÔʵÑéʹÓýØÍ¼¹¤¾ß½ØÍ¼²¢ÉÏ´«µ½Ïà¹ØÂÛ̳»ò¼¼ÊõÖ§³ÖÍøÕ¾£¬ÒÔ±ã»ñµÃ¸ü¶à×ÊÖú¡£
¼ì²ìÔÚÏßÎĵµ£ºÑÇÖÞIVÃØÍ¨³£ÌṩÏêϸµÄÔÚÏßʹÓÃÎĵµºÍFAQ£¬¿ÉÒÔ×ÊÖúÄú¸üºÃµØÁ˽âºÍʹÓøÃÈí¼þ¡£
¼ÓÈëÓû§ÉçÇø£º¼ÓÈëÑÇÖÞIVÃØµÄÓû§ÉçÇø£¬ÓëÆäËûÓû§·ÖÏíºÍ½»Á÷¾Ñ飬ÓÐʱ±ðÈ˵Ľâ¾ö¼Æ»®¿ÉÄÜ»á¸øÄú´øÀ´ÐµÄ˼·¡£
ÁªÏµ¼¼ÊõÖ§³Ö£ºÈç¹ûËùÓÐÒªÁì¶¼ÎÞ·¨½â¾öÎÊÌ⣬¿ÉÒÔÁªÏµÑÇÖÞIVÃØµÄ¼¼ÊõÖ§³Ö£¬ÌṩÏêϸµÄÎÊÌâÃèÊöºÍ½ØÍ¼£¬×¨Òµ¼¼ÊõÈËÔ±»áΪÄúÌṩ¸ü¾ßÌåµÄ½â¾ö¼Æ»®¡£
ͨ¹ýÒÔÉÏÏêϸµÄ°ì·¨Ï¢Õù¾ö¼Æ»®£¬ÏàÐÅÄúÄܹ»Ë³Àû½â¾öÔÚʹÓÃÑÇÖÞIVÃØÊ±Óöµ½µÄÂÒÂëÎÊÌ⣬ÏíÊÜÔ½·¢Ë³³©µÄʹÓÃÌåÑé¡£ÎÞÂÛÄúÊǼ¼ÊõÐÂÊÖÕÕ¾É×ÊÉîÓû§£¬Ï£ÍûÕâÆªÎÄÕÂÄÜΪÄúÌṩʵÓõÄÖ¸µ¼ºÍ×ÊÖú¡£
1Êý¾Ý¿â±àÂëÉèÖÃ
ÔÚÊý¾Ý¿âÉèÖÃÖУ¬È·±£Êý¾Ý¿âµÄ±àÂ뻨ÑùÓëÏîÄ¿ÖÐµÄÆäËû²¿·ÖÒ»Ö¡£ÀýÈ磬ÔÚMySQLÊý¾Ý¿âÖУ¬¿ÉÒÔͨ¹ýÒÔÏÂSQLÃüÁîÉèÖñàÂ룺
ALTERDATABASEyour_database_nameCHARACTERSETutf8COLLATEutf8_general_ci;
½¨Á¢¿çƽ̨¿ª·¢ÉçÇø£ºÎªÁ˽â¾ö¿ª·¢×ÊԴȱ·¦µÄÎÊÌ⣬½¨Ò齨Á¢Ò»¸ö¿çƽ̨¿ª·¢µÄ¼¼ÊõÉçÇø£¬ÓÉÐÐÒµÄڵĶ¥¼â¿ª·¢ÍŶÓÅäºÏ·ÖÏí¿ª·¢¾ÑéºÍ¼¼Êõ×ÊÔ´¡£Õ⽫ÓÐÖúÓÚÌáÉýÕû¸öÐÐÒµµÄ¿çƽ̨¿ª·¢ÄÜÁ¦¡£
ÔöÇ¿¼¼ÊõÅàѵ£ºÎªÁËÌá¸ß¿ª·¢ÈËÔ±µÄ¼¼Êõˮƽ£¬½¨Ò鿪չϵÁÐµÄ¿çÆ½Ì¨¿ª·¢Åàѵ£¬ÄÚÈݰüÀ¨×îеļ¼Êõ±ê×¼¡¢¿ª·¢¹¤¾ß¡¢Äþ¾²¼¼ÊõµÈ¡£Õ⽫ÓÐÖúÓÚÌáÉý¿ª·¢ÈËÔ±µÄ?¼¼ÊõÄÜÁ¦£¬´Ó¶ø¸üºÃµØÓ¦¶Ô¿çƽ̨ÎÊÌâ¡£
ʵʩ¿çƽ̨²âÊÔ£ºÎªÁËÈ·±£¿çƽ̨¿ª·¢µÄÖÊÁ¿£¬½¨ÒéÔÚ¿ª·¢Àú³ÌÖÐʵʩÑϸñµÄ¿çƽ̨²âÊÔ¡£Õâ°üÀ¨ÔÚ²î±ð²Ù×÷ϵͳºÍÉ豸ÉϽøÐй㷺µÄ²âÊÔ£¬ÒÔÈ·±£Êý¾Ý´«ÊäµÄ׼ȷÐÔºÍÄþ¾²ÐÔ¡£¿ª·¢ÍŶÓÓ¦°´ÆÚ½øÐÐ¿çÆ½Ì¨²âÊÔ£¬²¢ÔÚ²â?ÊÔÖз¢Ã÷ºÍÐÞ¸´ÎÊÌâ¡£
½ÓÄÉ΢ЧÀͼܹ¹£ºÎªÁ˸üºÃµØÓ¦¶Ô¿çƽ̨ÎÊÌ⣬½¨Òé½ÓÄÉ΢ЧÀͼܹ¹¡£Î¢Ð§ÀÍ¿ÉÒÔ½«Ó¦ÓóÌÐò²ð·ÖΪ¶à¸ö¶ÀÁ¢µÄЧÀÍ£¬Ã¿¸öЧÀÍ¿ÉÒÔ¶ÀÁ¢¿ª·¢ºÍ°²ÅÅ£¬´Ó¶ø¸üÈÝÒ×½øÐÐ¿çÆ½Ì¨¼æÈÝÐÔ²âÊÔºÍÓÅ»¯¡£
¸ß¼¶×Ö·û±àÂë´¦Àí
×Ö·û±àÂëÊÇ¡°ÑÇÖÞIVÃØÂÒÂ롱ÎÊÌâµÄÒ»¸öÖØÒª·½Ã档ΪÁ˸üºÃµØ´¦Àí×Ö·û±àÂëÎÊÌ⣬¿ÉÒԲο¼ÒÔϼ¼ÇÉ£º
×Ô¶¯±àÂë¼ì²â£ºÊ¹ÓÃ×Ô¶¯±àÂë¼ì²â¹¤¾ß£¬Èçchardet£¬À´¼ì²â×Ö·û±àÂ뻨Ñù£¬ÖÆÖ¹ÊÖ¶¯¼ì²éµÄ?¹ýʧ¡£±àÂëת»»£ºÔÚÊý¾Ý´«?ÊäºÍ´¦ÀíÀú³ÌÖУ¬Ê¹ÓñàÂëת»»¿â£¬ÈçPythonÖеÄcodecsÄ£¿é£¬½øÐбàÂ뻨ÑùµÄת»»£¬È·±£Êý¾ÝµÄÕýÈ·ÐÔºÍÒ»ÖÂÐÔ¡£Í³Ò»±àÂë±ê×¼£ºÔÚϵͳºÍÓ¦ÓóÌÐò¿ª·¢ÖУ¬Í³Ò»½ÓÄÉÒ»ÖÖ±àÂë±ê×¼£¬ÈçUTF-8£¬¼õÉÙ±àÂë³åÍ»µÄ¿ÉÄÜÐÔ¡£
У¶Ô£º·ëΰ¹â(p6mu9CWFoIx7YFddy4eQTuEboRc9VR7b9b)


