ÔÚ¹ú²úÈí¼þÁìÓò£¬ÂÒÂëÎÊÌâ¿Éν¡°Ë¾¿Õ¼û¹ß¡±£¬ÎÞÂÛÊÇ·¿ªÒ»¸öÖ÷ÒªÎļþ£¬ÕÕ¾ÉʹÓÃij¿îÌØ¶¨Èí¼þ£¬¶¼ÓпÉÄÜÓöµ½¡°ÎÄ×ÖÄð³É·½¿ò¡±¡¢¡°Îʺš±»ò¡°ÂÒÂë×Ö·û¡±µÄÞÏÞγ¡¾°¡£ÕâЩÎÊÌâ²»µ«Ó°ÏìÊÂÇéЧÂÊ£¬ÉõÖÁÔÚijЩÇéÐÎÏ»¹»áÔì³ÉÐÅϢת´ïµÄʧÎó¡£Òª¸ùÖι«Ë¾ÄÚÍâµÄÂÒÂë°ÃÄÕ£¬Ê×ÏȵÃÏàʶÂÒÂëµÄ¡°ÈªÔ´¡±¡£
¶àÄêÀ´£¬Óû§ºÍ¿ª·¢ÕßÓöµ½µÄÂÒÂëÀàÐÍÖ÷Òª¿ÉÒÔ¹éΪ¼¸´óÀࣺ
×Ö·û¼¯²»Æ¥ÅäÒýÆðµÄÂÒÂ룺ºÃ±È£¬½«UTF-8±àÂëµÄÎı¾ÓÃGBK»òGB2312·¿ª£¬ÈÝÒ×·ºÆð×Ö·û±äÐλòÂÒÂë¡£Õâ¸öÎÊÌâÔÚ¿çÆ½Ì¨¡¢¿çϵͳ²Ù×÷ʱÓÈΪ³£¼û¡£±àÂëתÂëÎó²î£ºÎļþÔÚÉúÑÄ»ò´«ÊäÀú³ÌÖУ¬±àÂëδ׼ȷת»»£¬µ¼Ö·¿ªÊ±ÏÔʾÂÒÂë¡£ÀýÈ磬´ÓÒ»¸öϵͳ¿½±´³öÀ´µÄÎı¾£¬±àÂëÃûÌÃ·×ÆçÖ£¬Ôì³ÉÏÔʾÒì³£¡£
×ÖÌåȱʧ»ò²»¼æÈÝ£º²¿·Ö×ÖÌå¿âȱʧ¶ÔÓ¦×Ö·û£¬»áÏÔʾΪ¡°·½¿é¡±»ò¡°Îʺ𱡣ÕâÔÚ²¿·Ö³ÌÐòÖнÏΪ³£¼û£¬ÓÈÆäÊÇÔÚʹÓùú²úÈí¼þʱ¡£Èí¼þÄÚ²¿ÉèÖÃÎÊÌ⣺һЩ¹ú²úÈí¼þûÓÐÌṩ±àÂëÉèÖÃÑ¡Ï»òÕßĬÈϽÓÄɲ»Ö§³ÖÖÐÎĵıàÂë·½·¨£¬Ò²»áÒý·¢ÂÒÂë¡£
±àÂë±ê×¼²»Í³Ò»£º×ݹۺ£ÄÚµÄÈí¼þÇéÐΣ¬¸÷³§ÉÌÒÔ¼°ÏµÍ³±£´æ²î±ðµÄ±àÂëϰ¹ß£¬ºÃ±ÈGBK¡¢GB2312¡¢UTF-8¡¢GB18030µÈ£¬Öйú¶Ô±àÂë±ê×¼µÄ¶àÑùÐÔµ¼Ö¡°»¥²»¼æÈÝ¡±ÎÊÌâ¡£Êý¾Ý´«ÊäÖеıàÂëת»»ÎÊÌ⣺ÔÚÍøÂç´«Êä»òÊý¾Ýµ¼Èëµ¼³öÀú³ÌÖУ¬±àÂëδͳһ£¬»òÒÅ©ÁËתÂë°ì·¨£¬ÈÝÒ×·ºÆðÂÒÂë¡£
ÕâÔÚ¾ÉϵͳǨáã»ò¶àƽ̨Ð×÷ÖÐÓÈΪͻ³ö¡£¿ª·¢ÕߵıàÂëÒâʶȱ·¦£º²¿·Ö¿ª·¢Ö°Ô±Ã»ÓÐÐγÉÓÅÒìµÄ±àÂëϰ¹ß£¬´úÂëÖÐÓ²±àÂë±àÂëÃûÌ㬻òδ¼ì²âÎļþ±àÂ룬µ¼Ö½çÃæ»òµ¼ÈëÄÚÈÝÂÒ³ÉÒ»¹øÖà¡£²Ù×÷ϵͳºÍ×ÖÌåȱÏÝ£º²¿·Ö¹ú²ú²Ù×÷ϵͳºÍ×ÖÌå¿âûÓÐÍêÕûÖ§³ÖËùÓÐÖÐÎÄ×Ö·û£¬»òĬÈÏ×ÖÌ岻ƥÅ䣬Ôì³ÉÏÔʾÒì³£¡£
½â¾öÂÒÂëµÄµÚÒ»²½£¬ÊÇÃ÷È·ÎÊÌâµÄÏêϸÌåÏֺͱ¬·¢Ôµ¹ÊÔÓÉ¡£¼¸ÖÖ³£¼ûÇéÐΣº
·¿ªÎļþºó£¬ÎÄ×ÖÄð³É²»ÊìϤµÄ·ûºÅ»ò·½¿é¡£Ä³Ð©Èí¼þÏÔʾÕý³££¬µ«µ¼³ö»òµ¼ÈëÊý¾Ýºó·ºÆðÂÒÂë¡£¸´ÖÆÕ³Ìùºó£¬×Ö·û·ºÆð¡°Îʺš±»ò¡°ºÚ¿ò¡±¡£Ä³Ð©×Ö·ûÔÚ²î±ðÈí¼þ»òϵͳÖÐÏÔʾ²î±ð£¬ÌåÏÖÁ˱àÂë²î±ð¡£
ʶ±ðºó£¬Æ¾Ö¤²î±ðÀàÐͽÓÄÉÏìÓ¦µÄ¼Æ»®£¬²Å»ªÊ°빦±¶¡£
ʹÓüÇʱ¾·¿ª¿ÉÒÉÎļþ£¬¿´×Ö·ûÊÇ·ñ·ºÆðÂÒÂë¡£¼ì²éÎļþµÄ±àÂëÃûÌã¨ÈçʹÓÃNotepad++¡¢SublimeTextµÈ¹¤¾ß£©¡£ÊµÑéÓòî±ðµÄ±àÂë·¿ª£¬ÖðÒ»ÑéÖ¤¡£Éó²éÈí¼þÉèÖã¬È·ÈÏĬÈϱàÂëÊÇ·ñ׼ȷ¡£Ê¹ÓÃרÃŵıàÂë¼ì²â¹¤¾ß£¬ºÃ±È¡°EncodingDetect¡±µÈ£¬¿ìËÙʶ±ðÎļþµÄÏÖʵ±àÂë¡£
×ܽáÒ»¾ä»°£ºÓöµ½ÂÒÂ룬²»Òª¾ª»Å¡ª¡ªÕÒµ½¡°ÎÊÌâµÄȪԴ¡±£¬ÇÉÓá°¹¤¾ß+¼¼ÇÉ¡±£¬Äã¾ÍÄÜÒý¡°ÂÒÂëÖ®Õ½¡±Îª¡°±àÂëʤÀû¡±¡£
¾ÓɵÚÒ»²¿·ÖµÄÆÊÎö£¬¸÷È˶ÔÂÒÂëµÄÀàÐÍÓëÔµ¹ÊÔÓÉÓÐÁËÆðÔ´ÊìϤ£¬¾ÍÊÇÏÂÊÖ½â¾öÂÒÂëµÄ¡°ÊµÕ½Õ½ÂÔ¡±¡£ÔÚ´Ë£¬ÎÒÃÇΪÄãÁгöÒ»·ÝÖÜÈ«µÄ¡°ÃØóÅÇåµ¥¡±£¬ÖúÄãÓ¦¶ÔÖÖÖÖÂÒÂ볡¾°£¬ÎÞÂÛÊÇÒ»Ñùƽ³£°ì¹«£¬Õվɿª·¢Î¬»¤¡£
ʹÓÃÎı¾±à¼Æ÷¼ì²â±àÂ룺ÀýÈ磬Notepad++ÔÚ¡°±àÂ롱²Ëµ¥ÖУ¬¿ÉÒÔ×Ô¶¯¼ì²â²¢Çл»±àÂë¡£ÖðһʵÑé²î±ð±àÂ룺UTF-8¡¢GBK¡¢GB2312¡¢GB18030¡¢Big5£¬Æ¾Ö¤ÎļþÏÖʵ±àÂëÖðһʵÑ飬ֱµ½×Ö·ûÕý³£ÏÔʾ¡£ÉèΪĬÈϱàÂë·¿ª£ºÒ»Ð©Èí¼þÖ§³ÖÉèÖÃĬÈϱàÂ룬ÀýÈçExcel¿ÉÒÔÏÞÖÆµ¼ÈëʱµÄ±àÂëÃûÌá£
ʹÓÃרҵת»»¹¤¾ß£ºÈçiconv¡¢Notepad++¡¢SublimeTextÖеġ°ÉúÑÄΪ¡±¹¦Ð§£¬½«Îļþת»»µ½Í³Ò»±àÂë¡£ÔÚ¿ª·¢»·½Ú¼ÓÂë¿Ø¹Ü£ºÔÚдÈëÊý¾Ý¿â»ò´æ´¢Îļþʱ£¬Ö¸¶¨Í³Ò»±àÂëÃûÌ᣺ñȣ¬MySQLÉèÖÃΪUTF-8£¬È·ÉúÑÄÈëµÄÎı¾²»»á·ºÆðÂÒÂë¡£
ÍøÂç´«Êä¼ÓÃÜ¡¢×ªÂ룺ÔÚÊý¾Ý´«Êä²ã£¬½ÓÄÉÖ§³ÖUnicodeµÄÐÒé»ò±àÂëÒªÁ죬×èÖ¹ÖÐÐÄ»·½ÚÍÉ»¯¡£
×°ÖÃÍêÕûµÄ¹ú²ú×ÖÌ壺Èç¡°ÆÓÖ±ºÚÌ塱¡¢¡°»ªÎÄ·ÂËΡ±µÈ£¬È·±£×Ö·û¿É±»×¼È·äÖȾ¡£ÏµÍ³×ÖÌåÉèÖãºÔÚ¿ØÖÆÃæ°åÖУ¬µ÷½âĬÈÏ×ÖÌ弯»®£¬Í³Ò»±ê×¼×ÖÌ壬×èÖ¹Òò×ÖÌåȱʧµ¼ÖµÄÂÒÂë¡£¸üвÙ×÷ϵͳºÍ×ÖÌå¿â£ºÈ·±£ÏµÍ³Ö§³Ö×îеıàÂë±ê×¼¼°×ÖÌå°ü£¬ïÔ̼æÈÝÎÊÌâ¡£
Èí¼þÄÚ²¿±àÂëÉèÖ㺼á³ÖÈí¼þµÄ±àÂëͳһ£¬ÀýÈ翪·¢Ê±É趨ËùÓÐÎı¾¼ÓÔØÎªUTF-8£¬È«Á÷³ÌÏà·û¡£±àÂë¼ì²âÓëµ÷ÊÔ£º¹ØÓÚ¿ª·¢Õߣ¬½¨ÒéÔÚ¶ÁÈ¡Êý¾Ýʱ¼ÓÈë±àÂë¼ì²â´úÂ룬°ü¹ÜÊý¾ÝÒ»ÖÂÐÔ¡£¹ú¼Ê»¯ÓëÍâµØ»¯µÄƽºâ£ºÊ¹ÓÃÏÖ´úµÄ¹ú¼Ê»¯¿ò¼Ü£¨ÈçICU¿â£©£¬´¦Öóͷ£¶àÓïÑÔ¡¢¶à±àÂë×Ö·ûÎÊÌ⣬×èÖ¹¡°ÂÒÂ롱·ºÆðÔÚÓû§½çÃæ¡£
ÅúÁ¿ÐÞ¸´¹¤¾ß£ºÊ¹Óþ籾»òÈí¼þ£¬ÊµÏÖÅúÁ¿¼ì²â¡¢×ª»»±àÂ룬½ÚԼʱ¼ä¡£ÕýÔò±í´ïʽÅú´¦Öóͷ££ºÊ¹ÓÃÕýÔò±í´ïʽ²éÕҷDZê×¼×Ö·û¡¢±àÂë²»¼æÈÝ×Ö·û£¬¾ÙÐÐ×Ô¶¯Ìæ»»»òÐÞ¸´¡£ÈÝ´íÉè¼Æ£º¿ª·¢Ê±Ë¼Á¿×Ö·ûÈÝ´í»úÖÆ£¬ºÃ±È¡°È±Ê§×Ö·ûÓ÷ûºÅÌæ»»¡±£¬×èÖ¹ÂÒÂëÉìÕÅ¡£
ÅàѵÓû§×Ö·ûÊäÈë¹æ·¶£º½¨Òéͳһ½ÓÄÉUTF-8±àÂëÊäÈ룬×èÖ¹±¬·¢ÂÒÂë¡£½¨Éè±àÂëͳһ±ê×¼£ºÆóÒµÄÚ²¿Öƶ©±àÂëÖÎÀí×¼Ôò£¬´ÓÔ´Í·±ÜÃâÂÒÂë·ºÆð¡£ÊµÊ±·´Ïì½â¾ö¼Æ»®£ºÒ»µ©Óöµ½ÂÒÂëÇéÐΣ¬·ÖÏí½â¾öÂÄÀú£¬ÌáÉýÍŶÓÕûÌå±àÂëËØÑø¡£
¼ì²é±àÂ룺ʶ±ð¡¢ÊµÑéÇл»£¬ÕÒµ½¡°×¼È·´úÂ롱¡£×ªÂëͳһ£ºÈ·±£Êý¾Ý´æ´¢¡¢´«Êä¡¢ÏÔʾµÄ±àÂëÒ»Ö¡£¸»ºñ×ÖÌ壺×èÖ¹Òò×ÖÌåȱʧµ¼ÖÂÏÔʾÒì³£¡£ÄÚÍâÁ¬Ïµ£º¿ªÀÄõü·â×°´¦Öóͷ£ºÃ±àÂ룬Óû§¶ËºÏÀíÉèÖÃ×ÖÌå¡£ÒÔÔ¤·ÀΪÏÈ£ºÇ¿»¯Á÷³Ì¹Ü¿Ø£¬Ìáǰ¶ÂסÂÒÂëµÄ¡°É¥¼Ò֮Ȯ¡±¡£
ÈôÊÇ×öµ½ÕâЩ£¬¹ú²úÈí¼þµÄÂÒÂëÎÊÌ⽫Öð²½ïÔÌ£¬Óû§ÌåÑé´ó·ùÌáÉý¡£ÏàÐÅÿ¸öÊÖÒÕÈ˶¼ÄܳÉΪ¡°±àÂëÊØ»¤Õß¡±£¬ÈÃÐÅϢת´ïÁ÷ͨÎÞ×è¡£
¡°ÂÒÂ롱£¬Ö»ÊDZàÂëÓëÈÏÖªµÄÕ½³¡£¬ÕÆÎÕÁË׼ȷսÂÔ£¬ÎÊÌâ²»¹ýÊÇ¡°ÅŲé+תÂë+ÓÅ»¯¡±µÄÌ×·ÓÎÏ·¡£
¶Ô¿¹ÂÒÂ룬Õⳡս¶·ÓÀÔ¶ÔÚ·ÉÏ£¬µ«ÓÐÁËÕâ·Ý¡°ÃØóÅÖ¸ÄÏ¡±£¬ÄãÒÑÕ¾ÔÚÁËÇÅÍ·±¤£¬ÓÄѶøÉÏ£¬Ó½Ó¡°×Ö·ûÎÞÕϰ¡±µÄÐÂʱ´ú£¡