mysqlÊý¾Ý¿âÂÒÂëÎÊÌâ
ÎÊÌâÃèÊö£º
Êý¾Ý¿âÖдæµÄÖÐÎÄÈ«²¿¶¼ÂÒÂ룬µ«ÊǶÁȡ֮ºóÔÚÒ³ÃæÖ®ºóÏÔʾµÄȴûÓÐÎÊÌ⣡
ÇëÎÊÕâÊÇÄÄÀï³öÁËÎÊÌ⣡£¿
set names 'gbk' »òÕßÄãµÄ×Ö·û¼¯¡£
°´ÕÕÏÂÌùÖеķ½·¨¼ì²éһϣ¬»òÕßÌṩÄãµÄ show create table , show variables
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
show variables like 'char%';
×Ö·û¼¯²»Í³Ò»
Èç¹ûÄãÊÇͨ¹ýJDBCÖ±½ÓÁ´½ÓÊý¾Ý¿âµÄʱºò£¬ÅäÖõĴúÂëÈçÏ£ºjdbc:mysql://localhost:3306 /workshopdb?useUnicode=true&characterEncoding=GBK£¬ÕâÑù±£Ö¤µ½Êý¾Ý¿âÖеĴúÂëÊDz»ÊÇÂÒÂë¡£
1£¬Êý¾Ý¿â·þÎñÆ÷¶ËÒÔʲô×Ö·û¼¯±£´æÖÐÎIJ¢Ã»ÓйØÏµ£¬Ö»ÒªÄÜ´æÏ¾ͿÉÒÔ¡£½¨ÒéÓÃUTF8
2£¬¿Í»§¶Ë±£´æºÍ¶ÁÈ¡ÏÔʾÖÐÎÄÖ»ÒªÊÇͳһ±àÂë¾Í¿ÉÒÔ¡£±ÈÈçÄãÓÃGBK±£´æ£¬¾ÍÓÃGBK¶ÁÈ¡ÏÔʾ£¬ÓÃUTF8±£´æ¾ÍÓÃUTF8¶ÁÈ¡ÏÔʾ¡£
ÄÇô¥Ö÷µÄÎÊÌâÒ³ÃæÏÔʾÕý³£¡£ÔÚmysqlÃüÁîÐв»Õý³£µÄ»°¡£Ö»ÒªÐÞ¸Ämy.ini
ÔÚ[Client]»òÕß[mysql]ÉèÖÃ
default-character-set=utf8 »òÕß GBK £¬±£³ÖºÍÄãÒ³Ãæ±£´æµÄ×Ö·û¼¯Ò»Ö¼´¿É¡£
×¢ÒâÊý¾Ý¿âÒѾÓÐÊý¾ÝÁË£¬¾Í²»ÒªÇáÒ×ÐÞ¸Ä[mysqld]ÀïÃæµÄdefault-character-set
Õâ¸öÉèÖÃ×îºÃÔÚ½¨Á¢Êý¾Ý¿âÖ®³õÉèÖúã¬È»ºó¾Í²»ÒªÐÞ¸ÄËü£¨ËäȻҲ¿ÉÒԸģ©¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......