ÔÚÏÖ´ú»¥ÁªÍøÓ¦ÓÃÖУ¬¡°ÑÇÖÞ¾«Æ·¿¨Ò»¿¨Èý¿¨ËÄ¿¨¡±µÈ¶àÖÖ¿¨Æ¬ºÍÊý¾Ý½»»¥·½·¨Öð½¥ÆÕ¼°£¬¼«´óµØÀû±ãÁËÓû§µÄ²Ù×÷ÌåÑé¡£Åãͬ×űã½ÝµÄʹÓÃÒ²´øÀ´ÁËһϵÁÐÊÖÒÕÄÑÌ⣬ÆäÖÐ×îÁîÈËÍ·Ì۵ļ´ÊÇ¡°ÂÒÂ롱ÎÊÌâ¡£ÕâÖÖÂÒÂë²»µ«Ó°ÏìÓû§µÄÕý³£²Ù×÷£¬¸ü¿ÉÄÜ´øÀ´ÐÅϢй¶ÉõÖÁÊý¾ÝË𻵵ÄÒþ»¼¡£
ΪºÎ»á·ºÆðÂÒÂ룿ÔõÑùÔÚʹÓÃÀú³ÌÖÐÓÐÓÃ×èÖ¹£¿±¾ÎĽ«ÎªÄúÏêϸ½â´ðÕâһϵÁÐÎÊÌâ¡£
Ò»¡¢ÂÒÂëµÄʵÖÊ£º±àÂë·×ÆçÖµÄħÖäÏàʶÂÒÂëµÄʵÖÊÊǽâ¾öÎÊÌâµÄµÚÒ»²½¡£ÂÒÂëͨ³£ÊÇÓɱàÂë·×ÆçÖÂÒýÆðµÄ¡£ÔÚÎÒÃÇÒ»Ñùƽ³£²Ù×÷ÖУ¬Êý¾ÝµÄ´æ´¢Óë´«Êä¶¼ÒÀÀµÒ»¶¨µÄ×Ö·û±àÂë±ê×¼£¬ÈçUTF-8¡¢GBK¡¢ASCIIµÈ¡£µ±²î±ðϵͳ»òÈí¼þÔÚ´¦Öóͷ£Í³Ò»Êý¾Ýʱ£¬±àÂë·½·¨·×ÆçÖ£¬¾Í»á·ºÆð³öÂÒÂë¡£
ÒÔ¡°ÑÇÖÞ¾«Æ·¿¨Ò»¿¨Èý¿¨ËÄ¿¨¡±ÎªÀý£¬ÈôÊǸÃÊý¾ÝÔÚ´æ´¢»ò´«ÊäÀú³ÌÖУ¬±àÂëÃûÌñ»ÎóÅлòת»»²»µ½Î»£¬Óû§ÔÚ½çÃæ»òÕß´òÓ¡³öÀ´µÄÄÚÈݾͿÉÄÜÄð³ÉһϵÁп´²»¶®µÄ·ûºÅ»ò×Ö·û¡£Õâ²»µ«Ó°ÏìÔĶÁÌåÑ飬ҲÔöÌíÁËÊý¾ÝÎó½âµÄΣº¦¡£
Êý¾Ý´«Êä»·½Úµ±Êý¾ÝÔÚ²î±ðϵͳ֮¼ä´«Êäʱ£¬ÈôÖÐÐÄûÓÐ׼ȷÉèÖñàÂëÃûÌ㬼«Ò×·ºÆðÂÒÂë¡£ÀýÈç£¬ÍøÕ¾´Óºǫ́Êý¾Ý¿â¶ÁÈ¡×Ö·ûÄÚÈÝ£¬ÈôÊý¾Ý¿â±àÂëΪUTF-8£¬µ«ÍøÒ³Í·²¿Î´ÉùÃ÷»òÉùÃ÷¹ýʧ£¬ÏÔʾ³öÀ´¾Í»á·ºÆðÂÒÂë¡£
Îļþ´æ´¢Óë¶ÁÈ¡Ðí¶àÓû§ÔÚÉúÑÄ»òµ¼³öÊý¾Ýʱ£¬Î´Ö¸¶¨×¼È·µÄ±àÂëÃûÌ㬻òÔÚ²î±ðƽ̨֮¼äÇл»²Ù×÷£¬µ¼ÖÂÎļþÄÚÈÝ·ºÆðÂÒÂë¡£ÓÈÆäÊÇÎı¾Îļþ¡¢ÉèÖÃÎļþ£¬ÈôÊDZàÂë·×ÆçÖ£¬ÄÚÈݾͻá±äµÃÎÞ·¨Ê¶±ð¡£
Èí¼þ¼æÈÝÐÔÎÊÌâ²î±ðÈí¼þÖ®¼äµÄ×Ö·û´¦Öóͷ£Õ½ÂÔ²î±ð£¬ÓÐЩÈí¼þĬÈϽÓÄÉGBK±àÂ룬ÓÐЩ½ÓÄÉUTF-8£¬ÉÐÓÐһЩÀϾÉϵͳ¿ÉÄÜÖ»Ö§³ÖASCII¡£ÔÚ¿çÈí¼þ²Ù×÷ʱ£¬ÈôûÓоÙÐбàÂëת»»£¬±Ø¶¨µ¼ÖÂÂÒÂë¡£
Èý¡¢ÔõÑùÌáǰԤ·ÀÂÒÂëΪÁË×èÖ¹¡°ÑÇÖÞ¾«Æ·¿¨Ò»¿¨Èý¿¨ËÄ¿¨¡±Ê¹ÓÃÖеÄÂÒÂëÎÊÌ⣬Ӧ´ÓÔ´Í·×öµ½·À¿Ø¡£Ïêϸ²½·¥ÈçÏ£º
ʹÓÃͳһµÄ±àÂë±ê×¼ÔÚ¿ª·¢ºÍ´æ´¢Àú³ÌÖУ¬ÓÅÏÈÑ¡ÔñUTF-8±àÂë¡£UTF-8¾ßÓмæÈÝÐÔÇ¿¡¢Ö§³Ö¶àÓïÑÔ×Ö·û¼¯µÄÌØµã£¬ÊÇÄ¿½ñ×îΪʢÐеıàÂë±ê×¼¡£
ÉèÖÃÃ÷È·µÄ±àÂëÉùÃ÷ÔÚÍøÒ³¡¢Ó¦ÓóÌÐò»òÉèÖÃÎļþÖУ¬È·±£ÉùÃ÷׼ȷµÄ±àÂë·½·¨¡£ÀýÈ磬ÔÚHTMLÖмÓÈ룬ÔÚHTTPÍ·ÖÐÉèÖÃContent-TypeΪUTF-8¡£
ʹÓÃÖ§³Ö¶à±àÂëµÄ¹¤¾ßÑ¡ÔñÖ§³Ö¶àÖÖ±àÂëÃûÌÃÇл»µÄ±à¼Æ÷ºÍ¿ª·¢¹¤¾ß£¬ÈçVSCode¡¢SublimeTextµÈ£¬È·±£ÔÚ²î±ðÇéÐÎÖе÷ÊÔʱ²»·ºÆðÂÒÂë¡£
½¨Éè±àÂëת»»Á÷³ÌÔÚÊý¾Ýµ¼Èë¡¢µ¼³ö»ò´«Êä»·½Ú£¬Ìáǰ¾ÙÐбàÂëת»»¡£ÀýÈ磬ʹÓÃiconv¹¤¾ß¾ÙÐбàÂëת»»£¬È·±£ÖÐÐÄ»·½Ú±àÂëÒ»Ö¡£
°´ÆÚ¾ÙÐÐϵͳĥÁ·¶ÔÊý¾Ý¿â¡¢Ð§ÀÍÆ÷¡¢Ó¦ÓóÌÐòµÈÒªº¦»·½Ú¾ÙÐбàÂëÒ»ÖÂÐÔ¼ì²â£¬×èÖ¹Òò°æ±¾²î±ð»òÉèÖùýʧµ¼ÖµıàÂëÎó²î¡£
ËÄ¡¢Óöµ½ÂÒÂëʱµÄ¿ìËÙÅŲéÓë½â¾ö¼Æ»®×ÝÈ»½ÓÄÉÁËÔ¤·À²½·¥£¬Ò²ÄÑÃâÔÚijЩ³¡ºÏÓöµ½ÂÒÂë¡£´Ëʱ£¬¿ìËÙÅŲéºÍÓÐÓýâ¾öÓÈΪÖ÷Òª¡£
¼ì²éÎļþºÍÒ³ÃæµÄ±àÂëÉùÃ÷È·±£ÎļþÉúÑÄʱΪUTF-8ÃûÌã¬ÍøÒ³Í·²¿×¼È·ÉùÃ÷±àÂ룬×èÖ¹ÒòÉùÃ÷¹ýʧÔì³ÉÂÒÂë¡£
Öð²½ÅŲéÊý¾ÝȪԴȷÈÏÊý¾ÝȪԴµÄ±àÂëÊÇ·ñÒ»Ö£¬ÌØÊâÊÇÔÚ¶àϵͳ¡¢¶àƽ̨²Ù×÷ʱ£¬ÒªÈ·±£ÊäÈë¡¢´æ´¢¡¢Êä³ö»·½Ú¶¼½ÓÄÉͳһµÄ±àÂë¡£
ʹÓù¤¾ß¾ÙÐбàÂë¼ì²âÓëת»»½èÖúNotepad++¡¢SublimeText¡¢iconvµÈ¹¤¾ß¼ì²éÎļþ±àÂ룬ÐëҪʱ¾ÙÐÐÅúÁ¿×ª»»¡£
¼ì²éä¯ÀÀÆ÷»ò¿Í»§¶ËÉèÖÃÓÐʱÂÒÂëÊÇÒòä¯ÀÀÆ÷»ò¿Í»§¶ËδÉèÖÃ׼ȷ±àÂ룬¿Éͨ¹ýÊÖ¶¯Çл»±àÂë·½·¨½â¾ö¡£
¸üÐÂÈí¼þ°æ±¾È·±£ËùÓÐÓ¦ÓóÌÐò¡¢Êý¾Ý¿âºÍϵͳ¶¼Îª×îа汾£¬Ö§³Ö×îеıàÂë±ê×¼¡£
Îå¡¢×ܽá×èÖ¹¡°ÑÇÖÞ¾«Æ·¿¨Ò»¿¨Èý¿¨ËÄ¿¨¡±Ê¹ÓÃÖеÄÂÒÂ룬Ҫº¦ÔÚÓÚÈ«Á÷³Ì°Ñ¿Ø±àÂë±ê×¼µÄÒ»ÖÂÐÔºÍʵÑéÑÏ¿áµÄ±àÂëÖÎÀí¡£´ÓÔ´Í·°ü¹Ü±àÂë¹æ·¶£¬Á¬ÏµÓÅÒìµÄ²Ù×÷ϰ¹ß£¬ÔÙ¼ÓÉÏ¿ìËÙÓÐÓõÄÅŲéÊֶΣ¬²Å»ªÈ·±£Êý¾ÝµÄ׼ȷת´ïºÍÏÔʾ¡£Ö»Òª¾«×¼ÕÆÎÕ±àÂëÒªÁ죬ÂÒÂëÎÊÌâ¾Í»á±äΪÀúÊ·£¬Óû§ÌåÑéÒ²»áËæÖ®ÌáÉý¡£
ÔÚǰһ²¿·ÖÖУ¬ÎÒÃÇÏêϸÆÊÎöÁËÂÒÂëµÄʵÖÊ¡¢Ôì³ÉÔµ¹ÊÔÓɼ°Ô¤·À²½·¥¡£ÏÖÔÚÌ죬ÎÒÃǽ«¸üÉîÈë̽Ë÷һЩÏȽøµÄÊÖÒÕ¹¤¾ßºÍÏÖʵ²Ù×÷¼¼ÇÉ£¬×ÊÖúÄúÔÚÃæÁÙ¡°ÑÇÖÞ¾«Æ·¿¨Ò»¿¨Èý¿¨ËÄ¿¨¡±Ê¹ÓÃÖеÄÂÒÂëÎÊÌâʱ£¬Äܹ»¼ÝÇá¾ÍÊ졢ʰ빦±¶¡£Ò²»áÏÈÈÝһЩÐÐÒµÖеÄ×î¼Ñʵ¼ù£¬ÈÃÄúÔÚÕâÒ»ÁìÓòÕ¾ÔÚÐÐÒÉϰ¶Ë¡£
±àÂë¼ì²â¹¤¾ßNotepad++£º³ýÁ˱༹¦Ð§£¬»¹Ö§³ÖÏÔʾËùÓÐ×Ö·ûµÄ±àÂëÐÅÏ¢£¬¿ÉÒÔ¿ìËÙÈ·ÈÏÎļþµÄÄ¿½ñ±àÂë״̬¡£VisualStudioCode£º¾ßÓÐǿʢµÄ±àÂë¼ì²â²å¼þ£¬¿ÉÒÔÒ»¼üÉó²éºÍÐÞ¸ÄÎļþ±àÂë¡£iconv£ºÒ»¸öÏÂÁîÐй¤¾ß£¬Ö§³ÖÅúÁ¿×ª»»Îı¾ÎļþµÄ±àÂëÃûÌã¬ÓÈÆäÊʺÏÐèÒª´¦Öóͷ£´ó×ÚÊý¾ÝµÄ³¡¾°¡£
±àÂë×Ô¶¯Ê¶±ðchardet£ºPythonÖеĿªÔ´¿â£¬ÓÃÓÚ×Ô¶¯¼ì²âÎļþ»òÍøÒ³µÄ±àÂëÃûÌã¬×ÊÖú¿ª·¢Õß¿ìËÙ¶¨Î»±àÂëÎÊÌâ¡£Êý¾Ý¿â±àÂëÖÎÀíʹÓÃMySQL¡¢PostgreSQLµÈÊý¾Ý¿âʱ£¬Ó¦É趨×Ö·û¼¯ÎªUTF-8£¬²¢ÔÚÅþÁ¬²ÎÊýÖÐÖ¸¶¨×¼È·µÄ×Ö·û¼¯£¬×èÖ¹´æ´¢Óë¶Áȡʱ·ºÆðÂÒÂë¡£
Êý¾ÝÊäÈë½×¶ÎÈ·±£ËùÓÐÊý¾ÝԴʹÓÃͳһ±ê×¼µÄ±àÂ룬ÈçɨÃèÉÏ´«Îĵµ¡¢API½Ó¿Ú´«Ê䣬¶¼Ó¦Ã÷È·»®¶¨±àÂë·½·¨²¢ÔÚ´úÂëÖÐÇ¿ÖÆÖ´ÐС£
ÖÐÐÄ´«Êä²ã¹ØÓÚ¿çÆ½Ì¨¡¢¶àϵͳµÄÊý¾Ý´«Ê䣬½¨Òé½ÓÄÉÖ§³Ö±àÂëתÂëµÄÖÐÐļþ»òÊðÀíЧÀÍÆ÷£¬ÊµÏÖ͸Ã÷µÄ±àÂëת»»¡£
´æ´¢Ó뱸·ÝÊý¾Ý¿âÉè¼ÆÊ±£¬Ó¦½ç˵׼ȷµÄ×Ö·û¼¯ºÍУ¶Ô¹æÔò£¨collation£©£¬×èÖ¹Òò×Ö·û¼¯²»Æ¥Åä´øÀ´µÄÂÒÂëÎÊÌâ¡£±¸·ÝÎļþÓ¦ÒÔͳһ±àÂëÃûÌÃÉúÑÄ¡£
ǰ¶ËÏÔÊ¾ÍøÒ³»òAPPÔÚäÖȾÊý¾Ýʱ£¬Ó¦ÔÚÒ³Ãæ´úÂëÖÐÃ÷È·ÉùÃ÷±àÂë¡£ÀýÈ磺£¬²¢È·±£ÏìӦͷÖеÄContent-Type׼ȷ¡£
°´ÆÚά»¤ÓëÅàѵ°´ÆÚ×éÖ¯ÊÖÒÕÅàѵ£¬ÌáÉýÍŶӶԱàÂë±ê×¼µÄÃ÷È·ºÍ²Ù×÷ÊÖÒÕ£¬Í¬Ê±Öƶ©ÏêϸµÄ±àÂëÖÎÀíÖÆ¶È£¬×èÖ¹ÈËΪÎó²Ù×÷¡£
Èý¡¢Ó¦¶Ô²î±ð³¡¾°µÄÂÒÂëÅŲéʵÀý°¸ÀýÒ»£ºÍøÒ³ÏÔʾÂÒÂë
Ôµ¹ÊÔÓÉ£ºÍøÒ³Î´É趨׼ȷµÄ×Ö·û¼¯½â¾ö£ºÔÚ±êÇ©ÖмÓÈ룬ȷÈÏHTTPÏìӦͷÖеÄContent-Type׼ȷÉèÖá£
Ôµ¹ÊÔÓÉ£ºµ¼³öÎļþ±àÂëÓëÏÖʵ´æ´¢±àÂë·×ÆçÖ½â¾ö£ºÔÚµ¼³ö¹¤¾ßÖÐÑ¡ÔñUTF-8±àÂ룬ȷ±£µ¼³öÎļþÄÚÈÝÕý³£ÏÔʾ¡£
Ôµ¹ÊÔÓÉ£ºÇëÇó»òÏìÓ¦µÄContent-TypeδÉùÃ÷׼ȷ±àÂë½â¾ö£ºÔÚHTTPÍ·ÖмÓÈëContent-Type:application/json;charset=UTF-8£¬È·±£Ç°ºó¶ËÒ»Ö¡£
ËÄ¡¢Î´À´Éú³¤Ç÷ÊÆ¡ª¡ªÖÇÄܱàÂëÖÎÀíËæ×ÅAIÓë´óÊý¾ÝÊÖÒÕµÄÉú³¤£¬±àÂëÖÎÀí½«ÏòÖÇÄÜ»¯Æ«ÏòÉú³¤¡£ÀýÈ磬ͨ¹ý»úеѧϰģ×Ó×Ô¶¯¼ì²âºÍÐÞÕý±àÂëÎó²î£¬ÊµÊ±¼à¿Ø±àÂëÒ»ÖÂÐԵȡ£ÕâЩÊÖÒÕ½«´ó´ó½µµÍÂÒÂ뱬·¢µÄ¿ÉÄÜÐÔ£¬Ìá¸ßÕû¸öÐÅÏ¢Á÷µÄ¿É¿¿ÐÔ¡£
Îå¡¢×ܽ᣺´ÓÊÖÒÕµ½ÖÎÀíÈ«·½Î»°ü¹Ü¡°ÑÇÖÞ¾«Æ·¿¨Ò»¿¨Èý¿¨ËÄ¿¨¡±Ê¹ÓÃÖзºÆðµÄÂÒÂëÎÊÌ⣬¼ÈÓÐÊÖÒÕ²ãÃæµÄÔµ¹ÊÔÓÉ£¬Ò²Éæ¼°ÖÎÀíºÍϰ¹ß¡£Á¬ÏµÏȽø¹¤¾ß¡¢ÐÐÒµ×î¼Ñʵ¼ùºÍδÀ´Ç÷ÊÆ£¬¿ÉÒÔÓÐÓÃÒÖÖÆÂÒÂ뱬·¢£¬ÎªÓû§Ìṩ¸üÇå¾²¡¢¸üÁ÷ͨµÄʹÓÃÌåÑé¡£
ÔÚÕâ¸öÊý×Ö»¯¿ìËÙÉú³¤µÄʱ´ú£¬ÕÆÎÕ׼ȷµÄ±àÂëÖÎÀíÕ½ÂÔ£¬ÎÞÒÉÊÇÿһ¸öÓ¦Óÿª·¢Õß¡¢ÏµÍ³ÖÎÀíÔ±µÄÖ÷ҪʹÃü¡£Ö»ÓÐÒ»Á¬ÓÅ»¯¡¢Ò»Ö±Á¢Ò죬²Å»ªÔÚ·±ÔÓµÄÐÅÏ¢ÌìÏÂÖУ¬ÊØ×¡Êý¾ÝµÄÇåÎúÓëÍêÕû¡£Ö»Òª¼á³ÖÊÖÒÕˢкÍÑÏ¿áÖÎÀí£¬ÂÒÂëÔÙÒ²²»ÊÇÄÑÌâ¡£