Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö£¨×Ü½áÆª£©

 mysqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö£¨×Ü½áÆª£©
 
µÚÒ»½â¾ö·½·¨£º
 
      ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕß¶¼Í³Ò»²ÅÐУº£¨ÒÔutf-8ΪÀý£©
1£ºÒ³ÃæÌá½»Êý¾Ý±àÂëutf-8£¨ÕâÒ²¿ÉÒÔËãÊÇÏÔÊ¾Ò³Ãæ±àÂ룩£¬
2£ºÊý¾Ý¿âдÈëʱ±àÂ룺alter database db default character set ‘utf8’collate ‘utf8-general-ci’£¬
3£ºÊý¾Ý¿â¶ÁȡʱËùÓñàÂ룺mysql_query£¨“set names ‘utf8’”£©£»
4£ºÏÔÊ¾Ò³Ãæ±àÂ룺<meta http-equiv="Content-type"content=“text/html, charset=utf-8”>
 
 
µÚ¶þ½â¾ö·½·¨£º
½øÈëMYSQLÃüÁîÐÐ:
mysql> alter database you_dbname default character set 'utf8';
mysql> SET character_set_client='utf8';
mysql> SET character_set_connection='utf8'
mysql> SET character_set_results='utf8'
 
 
µÚÈý½â¾ö·½·¨£º
£¨ÔÝʱֻÕë¶ÔMySQL 5.0.16 ÂÒÂëÎÊÌâ´¦Àí°ì·¨£¬ÆäËû°æ±¾Î´²âÊÔ¡££©
1 ÉèÖÃphpMyAdmin
¡¡¡¡Language£ºChinese simplified (zh-utf-8)
¡¡¡¡MySQL ×Ö·û¼¯£ºUTF-8 Unicode (utf8)
¡¡¡¡MySQL Á¬½ÓУ¶Ô£ºgbk_chinese_ci
2 ´´½¨Êý¾Ý¿âʱ
¡¡¡¡ÕûÀíÉèÖÃ³É gbk_chinese_ci
3 ÓÃSQL½¨Á¢±íÖÐ
¡¡¡¡ENGINE=MyISAM DEFAULT CHARSET=gbk;
¡¡¡¡ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=40 ;
4 ¼ì²é±í½á¹¹ÖÐ
¡¡¡¡varchar(100) µÄÕûÀíÊôÐÔΪgbk_chinese_ci
¡¡¡¡ÆäËüÀàÐ͵ÄÕûÀíÊôÐÔΪ¿Õ
5 ´úÂëÖмÓÉÏ
¡¡¡¡$db->query("SET CHARACTER SET GBK"); ¡¡LinuxÏÂÐèÒª£¬Windowsϲ»ÐèÒª
¡¡¡¡Õâ¸öÏ൱ÓÚConnection Character Sets and Collations
ÒÔÉÏÊǸöÈË´ÓÍøÉÏËÑË÷µÄһЩ×ܽáºÍ¹éÄÉ£¬ÏàÐÅÕâ¸öÓ¦¸ÃÄܽâ¾öËùÓÐÂÒÂëµÄÎÊÌâÁË¡£
±¾ÎIJ¿·ÖÄÚÈÝ×ªÔØ×Ôphp100.com£¬ÈçÓÐÎÊÌ⣬ÇëÓë±¾ÈËÁªÏµ¡£


Ïà¹ØÎĵµ£º

ÐÞ¸ÄMySQLĬÈÏÃÜÂëµÄ¾ßÌå²½Ö裨ת£©

access denied for user 'root'@'localhost' (using password: YES);
½ñÌìÓÃmysqlµÄʱºò£¬µÇ¼µÄʱºò³öÏÖÁËÕâ¾ä£¬²»ÖªµÀÊÇʲôÒâ˼£¬ÒòΪÎÒµÄmysqlÊÇ×°centosµÄʱºòÒ»Æð×°µÄ£¬ÃÜÂëÎÒ¾ÍÊäÈëÎÒµÄÕÊ»§ÃÜÂ룬½á¹û³öÏÖÁËÉÏÃæÄǾ䣻°Ù¶ÈÁËһϣ¬»¹Õæ²»ÉÙÈ˳öÏÖÁËÕâ¸öÎÊÌâ¡£¡£×îºóÎÒÕÒµ½ÁË·½·¨£»
[root@localhost home]# mysql - ......

ÈçºÎÐÞ¸ÄMySQL rootÃÜÂë

Íü¼ÇMySQL ROOTÃÜÂëÊÇÔÚMySQLʹÓÃÖкܳ£¼ûµÄÎÊÌ⣬¿ÉÊÇÓкܶàÅóÓѲ¢²»»áÖØÖÃROOTÃÜÂ룬Äǽпడ£¬ÎÒÓÐÉîÓид¥£¬ÌØÐ´´ËÎÄÕÂÓë´ó¼Ò½»Á÷£º
 
1¡¢±à¼­MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini
//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf ......

Mysql UTF8 ½â¾öÂÒÂë

1£¬ÉèÖÃmysqlĬÈϱàÂë
Ê×ÏȲéѯһÏÂshow variables like 'character%'; 
È·¶¨ËùÓеÄcharacter¶¼ÉèÖóÉutf-8  
²Î¿¼ http://www.diybl.com/course/7_databases/mysql/myxl/20081127/152726.html
mysql>show variables like 'character%';
+--------------------------+--------------------------- ......

ÉèÖÃmysqlĬÈϱàÂë

°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄmysqlÏ൱ÓÚwindowsÏÂmysqlµÄdateÎļþ¼Ð
Æô¶¯mysqlºó£¬ÒÔrootµÇ¼mysql
isher@isher-ubuntu:~$ mysql -u root
>show variables like 'character%'; #Ö´ÐбàÂëÏ ......

perlÒ»¸ö¼òµ¥mysql²Ù×÷µÄС³ÌÐò

#!/usr/bin/perl
use Mysql;
print "Content-type:
text/html \n\n";
# MySQL
ÅäÖñäÁ¿
$host = "localhost";
$database
= "testdb";
$tablename = "testtable";
$user = "username";
$pw =
"password";
# PERL MYSQL CONNECT()
$connect = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ