Mysql´íÎó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒÔÚMysqlÖж¼ÊÇÉèÖÃΪ gb2312µÄ£¬ÔÚEditorÒ²¿ÉÒ²²åÈëÖÐÎÄ£¬µ«ÊÇÔÚJavaÖвåÈëÖÐÎÄÊÇ×ÜÊÇÂÒÂ룬¶øÇÒServletÖÐÒ²ÊÇ response.setCharactorEncoding("gb2312");µÄ£¬Êä³öµ½¿ØÖÆÌ¨ÖеÄÒ²ÊÇÖÐÎÄ£¬µ«ÎªÊ²Ã´²åÈëµ½Êý¾Ý¿âÖеÄÈ«ÊÇÂÒÂ룿
show variables like 'char%'; Ìù½á¹û Á¬½ÓµÄurlºóÃæ¼ÓÉÏ£º jdbc:mysql://192.168.8.4:3306/test?characterEncoding=gb2312 ÊÔÊÔ¿´ ²Î¿¼ÏÂÌù¡£Ó¦¸ÃÊÇÄãÔÚJAVA³ÌÐòÖеÄ×Ö·û¼¯ÉèÖÃÎÊÌâ¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ì«¸ÐлÁË£¬¹ûÈ»ÔÚÁ¬½ÓµÄurlºóÃæ¼ÓÉÏ£º jdbc:mysql://192.168.8.4:3306/test?characterEncoding=gb2312¾Í¿ÉÒÔÁË£¬µ«ÊÇ ÎÒ»¹ÏëÎÊ£¬ÎªÊ²÷á:String test=new String(test.getBytes("gb2312")); ÕâÑù×ÓÔÚjavaÖÐתһ´Îºó£¬Ö±½Ó·ÅÈëÊý¾Ý¿âÈ´²»ÐÐÄØ£¿È´Ò»¶¨ÒªÔÚºóÃæ¼ÓÉϸögb2312ÄØ£¿ÒýÓà ̫¸ÐлÁË£¬¹ûÈ»ÔÚÁ¬½ÓµÄurlºóÃæ¼ÓÉÏ£º jdbc:mysql://192.168.8.4:3306/test?characterEncoding=gb2312¾Í¿ÉÒÔÁË£¬µ«ÊÇ ÎÒ»¹ÏëÎÊ£¬ÎªÊ²÷á:String test=new String(test.getBytes("gb2312")); ÕâÑù×ÓÔÚjavaÖÐתһ´Îºó£¬Ö±½Ó·ÅÈëÊý¾Ý¿âÈ´²»ÐÐÄØ£¿È´Ò»¶¨ÒªÔÚºóÃæ¼ÓÉϸögb2312ÄØ£¿ ÀǵÄÎÄÕ½âÊ͵ĺÜÇå³þ£¬È¥¿´¿´¡£mysqlµÄ×Ö·û¼¯×öµÄºÜϸ£¬Ã¿¸öµØ·½¶¼Òª×¢Òâͳһ¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£ µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£ Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£ quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£ È ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......