¹ØÓÚMySQLµÄ±àÂëÎÊÌâ
ÔÚmyeclipseÖÐʵÏÖÓëmysqlµÄÁ¬½Ó£¬µ«³öÏÖÁËÂÒÂëÏÖÏó£¬
mysqlÖеÄmy.iniÎļþÖÐĬÈϵͼÊÇlatin-1.ÎÊÔõôÑù²ÅÄÜÉèÖóÉutf-8»òÕßGBK¡£»¹ÓеľÍÊÇutf-8¡¢GBKºÍLatin-1ÈýÕßµÄÇø±ð
¸Ð¼¤²»¾¡
Â¥Ö÷×îºÃ»¹Êǽ«MysqlµÄ±àÂëÉèÖÃΪgb2312£¬ÖØ×°Ò»´ÎMysql£¬ÔÚÖØÐ½¨¸öÊý¾Ý¿â£¬
Latin-1²»Õ¦Ö§³ÖÖÐÎÄ£¬UTF-8Ö§³ÖÖÐÎÄ£¬GBKÖ§³ÖÖÐÎÄ£¬ÊÇ·±ÌåµÄ±àÂë
ÕâÖÖÎÊÌ⻹µÃ¿¿×Ô¼º Google.com.hk.............
latin-1 ¾ÍÊÇ ISO 8859-1 Ã÷°×ÁËô£¿
֨װ mysql ÅäÖÃÓïÑÔ»·¾³ÎªGBK
ʵÏÖmysqlÁ¬½Ó ÔÚÁ¬½Ó´Ê¼ÓÉÏ
?useEncoding=true&characterEncoding=UTF-8
¸ü¸ÄMySQLÊý¾Ý¿â±àÂ룺
ÔËÐÐMySQL Server Instance Confituration Wizard³ÌÐò£¬¸ù¾ÝÏòµ¼Ò»Ö±µã»÷¡°next¡±£¬µ±µ½ÅäÖÃÊý¾Ý¿â±àÂëÕâÒ»²½Ê±£¬×¢Ò⣬ѡÔñ×îºóÒ»¸öµ¥Ñ¡°´Å¥£¨Manual Selected Default Character Set/Collation£©£¬ÔÚÏÂÀ¿òÖÐÑ¡Ôñutf-8£¨Ä¬ÈϱàÂëΪlatin1£©£¬È»ºó°´Ïòµ¼Íê³ÉÅäÖü´¿É¡£
ÄãµÄJSPÎļþµÄÍ·ÎļþûÓÐÉèÖóÉutf-8°É£¿
Èç¹ûûÓеϰ¾Í²»Ö§³ÖÖÐÎÄ£¬¿Ï¶¨»áÂÒÂ룡
LZµÄÎÊÌâÎÒÓö¼û¹ý£¬ÄãÔÚ°²×°MYSQLµÄʱºò£¬ÓÐÒ»²½ÊÇ Please select the default set.Äã°ÑCharacter Set:Ñ¡ÔñΪGB2312¾ÍÐÐÁË
ÔÚ°²×°Ê±Óиö×Ö·ûÑ¡ÔñµÄÎÊÌâ £¬Ö»ÒªÑ¡ÎªGB2312¼´¿É
ÔËÐÐMySQL Server Instance Confituration WizardÀ´ÉèÖóÉutf-8£¬Êý¾Ý¿â¡¢±í¶¼ÒªÉèÖóÉutf-8¡£
°ÑÍøÒ³ÖеIJÎÊýת³Éutf-8¸ñʽ£¬´æÈëÊý¾Ý¿â¡£
Ö±½Ó²éѯ³öµÄÊý¾ÝÓ¦¸ÃÊÇutf-8µÄ¸ñʽ£¬²»ÓÃת»»¡£
ÒªÊÇÓô¿javaµÄ´úÂë´æÈëÊý¾ÝµÄ»°£¬Ò²ÓгöÏÖÂÒÂëµÄÇé¿ö¡£
ÍøÒ³ÖнÓÊܵÄÊý¾Ýת³Égb2312Ò²¿ÉÒÔ´æÈëÊý¾Ý¿âµÄ¡£
ÖØÐÂÅäÖÃmysql
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐÐ
µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
ÕâÊÇʲôÎÊÌ⣡£¡£¡
ÎÒÒѾ֪µÀÁË£¡
&n ......