myeclipse mysql²»ÈòåÈëÖÐÎÄ
Ê×ÏÈ¿´¿´ jspÎļþ java³ÌÐòÀïÓÐûÓÐrequest.setCharacterEncoding("UTF-8");
×Ö·û±àÂëÎÊÌ⣬Êý¾Ý²åÈë¿âÖÐʱ£¬java±àÂëºÍÊý¾Ý¿â±àÂë²»Ò»Ö£¬µ¼Ö²åÈëÊý¾Ý¿âΪÂÒÂ룬¿´µ½Îª£¿£¿£¿£¿µÄÐÎʽ
½«ÄãµÄjspÒ³Ãæ±àÂë¸ÄΪGBK£¬Êý¾Ý¿â¶ÔÓ¦±íµÄ±àÂëÒ²¸ÄΪGBK
±àÂëÒ»Ö£¬¾Í²»»á³öÏÖÂÒÂëÎÊÌâÁË
×Ö·û±àÂë²»¶Ô ¾Í»áÕâÑùÁË ÄãÔÚ½¨Êý¾Ý¿âµÄʱºò ×îºÃ¼ÓÉÏÕâÑùÒ»¾ä
create database tea default character set utf8 collate utf8_general_ci;
set names 'utf8';
ÕâÊǶÔÊý¾Ý¿âĬÈÏ×Ö·ûµÄÉèÖà ÒÔºó¶ÔÊý¾Ý¿âµÄ²Ù×÷¶¼»áʹÓÃutf8µÄ×Ö·û±àÂë
ÔÚÄãµÄ³ÌÐòÀï Ò²ÒªÊʵ±µÄ¶Ô×Ö·û½øÐд¦Àí ÕâÒª¸ù¾ÝµÄÄã³ÌÐò¶¨ ²»Ò»ÑùµÄ³ÌÐòÐ޸ĵÄÐÎʽ²»Ò»Ñù
ÏñÄãÒÔǰÔÚÃüÁî´°¿ÚÏÂʹÓÃMySQLÎÞ·¨²åÈëÖÐÎľÍÊǵäÐ͵Ä×Ö·û²»¶ÔÔì³ÉµÄ ÄãÔÚ¶ÔÊý¾Ý¿â²Ù×÷֮ǰ ×îºÃÔÚÃüÁî´°¿ÚÉèÖÃһϲÙ×÷ʱµÄ±àÂë
ÀýÈç setchar utf8;
ÕâÑù²åÈëµÄʱºò¾Í²»»á²å²»½øÈ¥ÁË
Ïà¹ØÎĵµ£º
Ô±¾µÄÄ¿µÄÊǽ«Êý¾Ý¿â´ÓMS SQL 2000Ç¨ÒÆµ½MySQLÖУ¬µ«ÌáʾJDBCÁ¬½Óʧ°Ü£¬ÎÞÄÎÖ®¼«£¬Ö»ºÃÑ¡ÔñÖмäÇÅÁºAccessÍê³ÉÕâÏîÁîÈËÌÖÑáµÄ¹¤×÷ÁË¡£
´ó¸Å²½ÖèÈçÏ£º
1£¬´ÓMS SQL 2000½«Êý¾Ýµ¼³öµ½AccessÖУ¬ÓÐ¹Ø±í¶¨ÒåºÃÖ÷¼üºÍ×Ô¶¯±àºÅ²¿·Ö²»È»Ç¨ÒƺóÓÖµÃÐÞ¸ÄMySQLµÄ±í¡£
2£¬ÐÞ¸ÄAccess±íÖйÜÀíÔ±×é¡¢¹ÜÀíÔ±µÄȨÏÞ£¬±£Ö¤AccessµÄÄÚÖà ......
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......
1. ÔÚʹÓÃNavicat 8 for MySQL¿Í»§¶Ë´´½¨Êý¾Ý¿âʱ£¬±àÂëµÄÉèÖÃÈçÏÂͼ£º
2. ½«°²×°Ä¿Â¼F:\MySQL\MySQL Server 5.1Ï£¬my.iniÎļþÉèÖñäÁ¿Öµdefault-character-set=gbk £¨°üº¬Á½´¦£¬¿É²éÕÒdefault-character-set£©£¬È»ºóÖØÆôMYSQL·þÎñ¡£ ......