¿çÎÄ»¯½»Á÷ÖеÄÓïÑԺͷÒëÎÊÌâ
ÔÚ¿çÎÄ»¯½»Á÷ÖУ¬ÓïÑԺͷÒëÎÊÌâÒ²»áµ¼Ö±àÂë·×ÆçÖ¡£ÌرðÊÇÔÚ¶àÓïÑÔÇé¿öÏ£¬²î±ðÓïÑÔÖ®¼äµÄ×Ö·û±àÂë²î±ðºÍ·Òë¹ýʧ£¬¿ÉÄÜ»áÒý·¢±àÂëÎÊÌâ¡£
ΪÁËÓ¦¶ÔÕâÒ»ÎÊÌ⣬ÎÒÃÇÐèÒªÔÚ¿çÎÄ»¯½»Á÷ÖУ¬¾¡Á¿Ê¹ÓÃͳһµÄ±àÂë±ê×¼ºÍ×Ö·û¼¯¡£ÀýÈ磬ÔÚ¹ú¼ÊÉÌÒµÏàͬÖУ¬¿ÉÒÔʹÓÃUnicode±àÂ룬ÒÔÈ·±£²î±ðÓïÑÔµÄÎı¾Äܹ»Õýȷͨ±¨ºÍÏÔʾ¡£ÔÚ·ÒëÀú³ÌÖУ¬Ó¦¾¡Á¿Ñ¡ÔñרҵµÄ·ÒëЧÀͺ͹¤¾ß£¬ÒÔ¼õÉÙ·Òë¹ýʧ¶Ô±àÂëµÄÓ°Ïì¡£
¿ª¶Ë¼ì²âÓëʶ±ð
ÔÚÈ·ÈÏÃØÂÒÂëÎÊÌâ֮ǰ£¬ÐèÒª¶ÔÊý¾Ý½øÐпª¶Ë¼ì²â¡£¿ÉÒÔͨ¹ýÒÔÏÂÒªÁìʶ±ðDZÔÚµÄÃØÂÒÂëÎÊÌ⣺
Êý¾ÝÒ»ÖÂÐÔ¼ì²é£º±È½ÏÔʼÊý¾ÝÓë´¦ÀíºóµÄÊý¾Ý£¬¼ì²ìÊÇ·ñ´æ?ÔÚ·×ÆçÖµÄÇé¿ö¡£±àÂ뻨Ñù¼ì²é£ºÈ·ÈÏÊý¾ÝÎļþµÄ±àÂ뻨ÑùÊÇ·ñÕýÈ·£¬ÈçUTF-8¡¢GBKµÈ¡£Êý¾ÝУÑ飺ʹÓùþÏ£Ëã·¨»òÆäËûУÑéÒªÁ죬ȷ±£Êý¾ÝÔÚ´«Êä»ò´æ´¢Àú³ÌÖÐδ±»¸Ä¶¯¡£
ºó¶ËʵÏÖÒªÁì
Êý¾Ý¿â±àÂëÉèÖãºÈ·±£Êý¾Ý¿âºÍ±íµÄ±àÂ뻨ÑùΪUTF-8¡£ÔÚ´´Á¢Êý¾Ý¿âºÍ±íʱ£¬¿ÉÒÔʹÓÃÒÔÏÂSQLÓï¾ä£ºCREATEDATABASEmydatabaseCHARACTERSETutf8mb4COLLATEutf8mb4_unicode_ci;CREATETABLEmytable(idINTAUTO_INCREMENTPRIMARYKEY,nameVARCHAR(255)CHARACTERSETutf8mb4COLLATEutf8mb4_unicode_ci);Êý¾Ý´¦ÀíºÍ´æ´¢£ºÔÚÊý¾Ý´¦ÀíºÍ´æ´¢?Àú³ÌÖУ¬È·±£?ʹÓÃUTF-8±àÂ뻨Ñù¡£
ÀýÈ磬ÔÚʹÓÃPython´¦ÀíÊý¾Ýʱ£¬¿ÉÒÔʹÓÃÒÔÏ´úÂ룺importcodecswithcodecs.open('file.txt','r','utf-8')asf:data=f.read()
×ܽá
Á˽âÑÇÖÞIVÉ豸µÄ?»ù´¡ÖªÊ¶ºÍ³£¼ûÎÊÌ⣬ÒÔ¼°ÕÆÎÕ»ù±¾µÄ¹ÊÕÏÅŲ鼼ÇÉ£¬¿ÉÒÔ´ó´óÌá¸ßÎÒÃÇ´¦ÀíÉ豸ÎÊÌâµÄ?ЧÂʺÍ׼ȷÐÔ¡£ÔÚÏÂÒ»²¿·Ö£¬ÎÒÃǽ«ÉîÈë̽Ìָ߼¶¹ÊÕÏÅŲé?¼¼ÊõºÍÅÓ´óÎÊÌâµÄ½â¾öÒªÁì¡£
ÔÚÑÇÖÞIVÃØÂÒÂë¹ÊÕÏÅŲéÓëÐÞ¸´ÒªÁìÏê½âµÄµÚ¶þ²¿·Ö£¬ÎÒÃǽ«ÉîÈë̽Ìָ߼¶¹ÊÕÏÅŲé?¼¼ÊõºÍÅÓ´óÎÊÌâµÄ½â¾öÒªÁ죬°ï?Öú¶ÁÕß½øÒ»²½ÌáÉý¼¼Êõˮƽ¡£
½á¹û£º
¾¹ýÉÏÊö²½·¥µÄʵʩ£¬½ðÈÚ»ú¹¹µÄϵͳ»Ö¸´ÁËÕý³£ÔËÐУ¬ÂÒÂëÎÊÌâ»ñµÃÁËÓÐЧ½â¾ö£¬ÒµÎñϵͳµÄÎȶ¨ÐԺͿɿ¿ÐÔÏÔÖøÌá¸ß¡£
ͨ¹ý±¾ÎĵÄÏêϸ½éÉܺÍʵ¼Ê°¸ÀýµÄÆÊÎö£¬ÏàÐÅÄãÒѾ¶Ô¡°ÑÇÖÞIVÃØÂÒÂ롱ÎÊÌâµÄÐÞ¸´ÓÐÁ˸üÉîÈëµÄÀí½â¡£Ï£ÍûÕâЩ¼¼ÇɺÍ×î¼Ñʵ¼ùÄܹ»ÔÚÄãµÄʵ¼ÊÊÂÇéÖз¢»Ó×÷Óã¬×ÊÖúÄã¸ßЧ½â¾ö¼¼ÊõÎÊÌâ¡£
×ܽá
ÑÇÖÞIVÃØÂÒÂëÏÖÏóµÄÉú³ÉÔÒòºÍ×Ö·û¼¯¼æÈÝÐÔÎÊÌ⣬ÊÇÐÅÏ¢¼¼ÊõÁìÓòÖеÄÖØÒª¿ÎÌ⡣ͨ¹ý¶ÔÕâÒ»ÏÖÏóµÄÈ«Ãæ½âÎö£¬ÎÒÃÇ¿ÉÒÔ¸üÇåÎúµØÓß½âÆä±³ºóµÄ»úÖÆ£¬²¢½ÓÄÉÓÐЧµÄÕ½ÂÔÀ´ÖÆÖ¹ÂÒÂëÎÊÌâ¡£ÎÞÂÛÊÇÔÚϵͳÉè¼Æ¡¢Êý¾Ý´«ÊäÕÕ¾ÉÈí¼þ¿ª·¢ÖУ¬Í³Ò»×Ö·û±àÂë¡¢Ñϸñ¿ØÖÆÊý¾Ý´«Ê䡢ʵÏÖ±àÂëת»»ºÍÌá¸ßÈí¼þ¼æÈÝÐÔ£¬¶¼Êǽâ¾öÕâÒ»ÎÊÌâµÄÒªº¦²½·¥¡£
ͨ¹ýÕâЩ²½·¥£¬ÎÒÃÇ¿ÉÒÔÈ·±£Êý¾ÝµÄ׼ȷÐԺͿɿ¿ÐÔ£¬Ìá¸ßÐÅÏ¢¼¼ÊõÓ¦ÓõÄÖÊÁ¿ºÍЧÂÊ¡£
PostgreSQL£ºÔÚPostgreSQLÊý¾Ý¿âÖУ¬¿ÉÒÔͨ¹ýÉèÖÃserver_encodingºÍclient_encodingÀ´ÊµÏÖͳһ±àÂë¡£APIºÍ¿â£ºPython£ºÔÚPythonÖУ¬¿ÉÒÔʹÓÃcodecsÄ£¿é½øÐбàÂëת»»£¬²¢ÇÒrequests¿âÔÚ´¦ÀíHTTPÇëÇóʱ¿ÉÒÔ×Ô¶¯´¦Àí±àÂëÎÊÌâ¡£
Java£ºÔÚJavaÖУ¬¿ÉÒÔʹÓÃInputStreamReaderºÍOutputStreamWriterÀ´´¦Àí±àÂëת»»¡£ÔÚÏß×ÊÔ´ºÍÎĵµ£º¹Ù·½Îĵµ£ºÖÖÖÖÈí¼þºÍ±à³ÌÓïÑԵĹٷ½ÎĵµÍ¨³£»áÏêϸ½éÉÜÈçºÎÉèÖúʹ¦Àí±à?ÂëÎÊÌâ¡£±à³ÌÉçÇøºÍÂÛ̳£ºÈçStackOverflow¡¢GitHubµÈ£¬¶¼ÊÇ»ñÈ¡±àÂë½â¾ö¼Æ»®ºÍ×î¼Ñʵ¼ùµÄºÃµØ·½¡£
µ©È·ÈÏÁ˱àÂëÎÊÌ⣬ÏÂÒ»²½¾ÍÊÇÉèÖÃÕýÈ·µÄ±àÂ룺
ÍøÒ³¿ª·¢£ºÔÚHTMLÎļþµÄÍ·²¿Ìí¼Ó£¬È·±£ÍøÒ³Ê¹ÓÃUTF-8±à?Â뻨Ñù¡£ÔÚЧÀÍÆ÷¶Ë´úÂëÖУ¬Ò²ÐèÒªÉèÖÃÕýÈ·µÄ±àÂ뻨Ñù£¬ÈçÔÚPHPÖпÉÒÔʹÓÃheader('Content-Type:text/html;charset=UTF-8');¡£
Êý¾Ý¿â²Ù×÷£ºÔÚÊý¾Ý¿â²Ù×÷ÖУ¬È·±£ËùÓеÄSQLÓï¾äÖж¼Ö¸¶¨ÁËÕýÈ·µÄ±àÂ뻨Ñù¡£ÀýÈ磬ÔÚMySQLÖпÉÒÔʹÓÃSETNAMESUTF8;À´ÉèÖñàÂë¡£
У¶Ô£ºÕžÒå(p6mu9CWFoIx7YFddy4eQTuEboRc9VR7b9b)


