mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º
mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º
1 ÃüÁî²ì¿´×Ö·ûÉèÖá£
mysql> show variables like "%char%";
2 ½«²»ÊÇutf-8µÄ¶¼¸Ä³Éutf8¡£Ö»ÓÐfilesystem²»±ä;
| Variable_name | Value
|
+--------------------------+--------
--------------------------------+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | utf8
|
| character_set_server | utf8
|
| character_set_system &
Ïà¹ØÎĵµ£º
ÓÅ»¯MySQL·þÎñÆ÷µÄÅäÖòÎÊý£¬¿ÉÒÔÌá¸ßMySQLÊý¾Ý¿âµÄÐÔÄÜ£¬µ«ÊǶÔÓÚÅäÖýϵ͵ķþÎñÆ÷À´Ëµ£¬ÄãÎÞÂÛÔõôÓÅ»¯ÅäÖ㬶¼²»»áµÃµ½ÀíÏëµÄЧ¹û£¬ÄǾÍÖ»ÄÜÌá¸ßÄãÓ²¼þÅäÖã¬À´³¹µ×ÓÐЧµØ¸ÄÉÆ·þÎñÆ÷µÄÐÔÄÜ¡£
¾ßÌåµÄ·½·¨ÈçÏ£º
Ò»¡¢ÔÚÉèÖÃMySQL ʱ£¬Ó¦¸ÃÅäÖÃÆäʹÓþ²Ì¬¿â¶ø²»Êǹ²Ïí¿â¡£Ê¹Óù²Ïí¿âµÄ¶¯Ì¬¶þ½øÖÆÏµÍ³¿É½ÚÊ¡´ÅÅ̿ռ䣬µ«¾² ......
Ò»°ãÈË×ÜÊÇÒòΪĿ¹â¶Ìdz¶ø´íʧ׬Ǯ»ú»á£¬larry ÔÚÑÛ¹â·½Ãæ×ÜÄÜ¿´µÄ³¤Ô¶£¬ÒÔǰһϵÁеÄÊÕ¹º×ãÒÔÖ¤Ã÷¡£²»¹ýÕâ´Î¾Ü¾øÅ·ÃË»á¸øOracle´øÀ´ºÜ´óµÄÂé·³£¬Å·ÖÞÊг¡²»ÒªÁË£¿ ÎÒ²ÂÒ²Ðí»á´ò¹Ù˾¡£ Oracle¶ÔSAPÏòÀ´³ðÊÓ£¬Õâ´ÎSAPÀûÓÃÅ·ÃË´òÁËÒ»¸öƯÁÁµÄ·ü»÷Õ½£¬½ÓÏÂÀ´¾Í¿´OracleÔõô·´»÷ÁË£¬ÊÃÄ¿ÒÔ´ý¡£
......
Ê×ÏÈ·ÅÖúÃjdbcÇý¶¯³ÌÐò£¬ÔÚ java\jre6\lib\ext\Ï£¬java\jdk1.6\jre\libµÈµØ·½¶¼·ÅÆðÀ´£¬ÒòΪ²»È·¶¨ÔÚÄÄÀïÓÐÓ÷··
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost/DATABASENAME?user=USERNAME&password=PASSWORD&useUnicode=tru ......
¹Ø¼ü×Ö: mysql6 mysql6ÏÂÔØ
×÷ΪһÃû¿ª·¢ÈËÔ±,ÎÒ¶ÔÂÌɫСÈí¼þÇéÓжÀÖÓ,ÒòΪÓÃÆðÀ´·½±ã¿ì½ÝÂï,±ãÓÚЯ´ø,Ò×ÓÚÔÚÑÝʾϵͳÖÐʹÓÃ,¿ª·¢Ê±¿ÉÁ¢¼´½øÈë״̬. £¨ÔÚ¸½¼þÖУ©
ÒÔÏÂÊÇÏêϸ˵Ã÷:
MySQL 6 ÂÌÉ«¾«¼ò°æ(BAT°æ±¾)
MySQL 6 Ö§³ÖÍâ¼ü,ÊÓͼ´æ´¢¹ý³Ì,ÊÂÎñµÈ¹¦ÄÜ(ÂÌÉ«¾« ......
ÓÉÓÚ×î½üÒ»Ö±ÔÚÁ˽âmysql¡£¸÷ÖÖ±íÀàÐ͵ÄÊý¾Ý´æ´¢ÒÔ¼°Ïà¹ØÏÞÖÆ¾ÍÊDZØÐëÁ˽âµÄ·½ÃæÁË¡£
×Ô¼ºµÄ·þÎñÆ÷»·¾³£ºOS Cent OS ext3£¬memory 4G£¬ disk 2T block size 4K¡£
¾µ÷²é£¬linuxÏÂÎļþ×î´óÊÇ´æÔÚÏÞÖÆµÄ¡£È¥googleÉÏËÑÁËËÑ£¬´ó¼Ò˵·¨²»Ò»£¬×îÖÕ×Ô¼º»¹ÊÇÕÒµ½±È½Ï¹Ù·½µÄ˵¡£Ïê¼ûhttp://en.wikipedia.org/wiki/Ext3 ËùÒÔ× ......