mysqlÃüÁîÐпͻ§¶ËÏÔʾÂÒÂë
mysqlÃüÁîÐпͻ§¶ËÏÔʾÂÒÂë
mysql> select * from userinfo;
+--------+----------+----------+------+-----------+-----------+
| autoid | username | password | sex | realname | qq |
+--------+----------+----------+------+-----------+-----------+
| 1 | xiaoqing | 1234 | 鐢? | xiaoxiao | 569823 |
| 2 | boys | 123 | å¥? | æ¢侀綈鐑? | 395423086 |
| 3 | xiao7 | xiao7520 | 鐢? | 鍛µå懙 | 鍛µå懙 |
+--------+----------+----------+------+-----------+-----------+
µ«ÊÇÎÒÓÿÉÊÓ»¯µÄÈí¼þ EMS SQL Manager 2005 Lite for MySQL
¿´µ½µÄÊý¾ÝÈ´ÄÜÕýÈ·ÏÔʾÖÐÎÄ
ÇëÎÊÕâ¸öÎÊÌâÈçºÎ½â¾ö?Çë¸ßÊִͽÌ.
×Ö·û¼¯µÄÎÊÌ⣬Èç¹ûÊÇ gb2312 / gbk Ôò set names һϾÍÐÐÁË£¬Èç¹ûÊÇUTF8£¬ÔòÄãµÄDOS²»Ö§³ÖUTF8´ÓMYSQLÖÐÏÔʾ¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
set names gbk;¾Í¿ÉÒÔ¡£(¸Ä±ä¿Í»§¶Ë±àÂë)
SQL code:
mysql> show variables like "%char%";
+--------------------------+------------------------------------------
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõģ¬µ«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶
ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ
²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵģ¬¶ÔC ......
ÈÕIPÊýǧ ÒÔºó»áÉÏÍò Ò²ÊÇflex+javaÓÎÏ·ÀàÐ͵ÄÍøÕ¾ ¼¯ÖÐÔڸ߷åÆÚÍíÉÏ
ÇëÎÊÊý¾Ý¿â·þÎñÆ÷µÄ»úÆ÷ÓÃʲôƷÅƺã¿ÍƼöÒ»¸öÅäÖã¿
ÏÖÔÚÊý¾Ý¿âÊÇʹÓÃmysql5.0 ÊDz»ÊÇÊʺϣ¿ ¸Ã²»¸Ã»»³ÉOralce(ÏÖÔÚ»»»¹ ......