ASA 資料庫資料亂碼問題解決方案

2007Õ╣┤09µ£ê29µùÑ

 

Õ¢ôASAµò░µì«Õ║ôÕ╝òµôÄþëêµ£¼ÕÉîµò░µì«Õ║ô(*.DB)õ©ìÕÉîþÜäµùÂÕÇÖ,µêûÞÇൣëÕàÂÕ«âÕăÕøáÞÇîÕ»╝Þç┤µò░µì«Õç║þÄ░õ╣▒þáü.µé¿ÕÅ»õ╗ÑÞ»òÞ»òõ©ïÚØóþÜäµû╣µ│ò,õ╣ƒÞ«©Þâ¢Õ©«õ©èõ¢áþÜäÕ┐ÖÕÖó.

µû╣µ│òõ©Ç:þ«ÇÕìò!!õ¢åµÿ»ÕÑ¢Õâŵ£ëþé╣µ▓╗µáçõ©ìµ▓╗µ£¼

┬á┬á┬á┬á┬á┬áÔùÅÕ£¿Þ«¥þ¢«µò░µì«µ║ÉþÜäµùÂÕÇÖ,Þ«¥þ¢«Õ¡ùþ¼ªÚøå!µû╣µ│òµÿ»:ODBCµò░µì«µ║Éþ«íþÉåÕÖ¿ÔåÆÚàìþ¢«þø©Õ║öþÜäµò░µì«µ║É,µëôÕ╝ÇÚàìþ¢«þ¬ùÕÅúÔåÆÚÇëµï®Advancedµáçþ¡¥:Þ«¥þ¢« Character setõ©║:iso_1µêûcp850,õ©ÇÞê¼þö¿iso_1Õ░▒ÕÅ»õ╗Ñõ║å.

┬á┬á┬á┬á┬á┬áÔùÅÕªéµ×£þö¿pbÕ╝ÇÕÅæ,Úéúõ╣êõ╣ƒÕÅ»õ╗ÑÕ£¿pbÕ╝ÇÕÅæþÄ»Õóâõ©¡Úàìþ¢«ÕÅéµò░,Õì│:Driver-specific parametersõ©¡Þ«¥þ¢«:charset=cp850

µû╣µ│òõ║î:ÕñìµØéþé╣.

1. Õì©Þ¢¢µò░µì«Õ║ô,Õ╣Âõ┐ØÕ¡ÿÕñçõ╗¢µò░µì«µûçõ╗Â( Õ╗║Þ««ÕàêÕñçõ╗¢µûçõ╗ ):

┬á┬á┬á┬á┬á┬á┬á┬á µëôÕ╝ÇSybase┬á┬á CentralÔåÆUtilitiesÔåÆÞ┐×µÄÑõ¢áþÜäµò░µì«Õ║ô(ÕÀÑÕàÀµáŵîëÚÆ«)ÔåÆUnload Database(Õì©Þ¢¢db)ÔåÆõ┐ØÕ¡ÿreload.sql

2. µû░Õ╗║µò░µì«Õ║ô,þö¿µØѵëºÞíîÕñçõ╗¢µûçõ╗Â:

┬á┬á┬á┬á┬á┬á┬á┬áÕ£¿Sybase┬á┬á CentralÔåÆCreate database

3. µëºÞíîÕñçõ╗¢µûçõ╗Â(reload.sql):

┬á┬á┬á┬á┬á┬á┬á┬áÕ£¿Sybase┬á┬á CentralÔåÆOpen Interactive SQLµëºÞíîÕêܵëìþÜäÕñçõ╗¢µûçõ╗Â.

┬á┬á┬á┬á┬á┬á┬á┬áµêûÞÇà Õ£¿Pbõ©¡µëºÞíîõ╣ƒÕÅ»õ╗Ñ.