MysqlÂÒÂë
PHP ´æÈ¡ MySQL ÂÒÂëÎÊÌâ
ÉÏһƪ / ÏÂһƪ 2007-06-04 03:33:50 / ¸öÈË·ÖÀࣺPHPѧϰ
²é¿´( 239 ) / ÆÀÂÛ( 0 ) / ÆÀ·Ö( 0 / 0 )
MySQL µÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺×Ö·û¼¯(Character set)ºÍÅÅÐò·½Ê½(Collation)¡£¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î: ·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í(table)ºÍÁ¬½Ó£¨connection£©¡£
²é¿´ÏµÍ³µÄ×Ö·û¼¯ºÍÅÅÐò·½Ê½µÄÉ趨¿ÉÒÔͨ¹ýÏÂÃæµÄÁ½ÌõÃüÁ
²é¿´×Ö·û¼¯£º
mysql> SHOW VARIABLES LIKE 'character_set_%';
ÏÔʾ×Ö·û¼¯ÉèÖÃÈçÏ£º
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
²é¿´ÅÅÐò·½Ê½(Collation)
mysql> SHOW VARIABLES LIKE 'collation_%';
ÏÔʾĬÈÏÖµ£º
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
ÉÏÃæÁгöµÄÖµ¾ÍÊÇϵͳµÄĬÈÏÖµ¡£Èç¹ûÄãÆæ¹ÖϵͳÔõôĬÈÏÊÇlatin1µÄÈðµäÓïÅÅÐò·½Ê½,ÔÒòÊÇMySQLÓÉÈðµäµÄT.c.X.DataKonsultAB¹«Ë¾(Ŀǰ¹«Ë¾Ãû³ÆÎªMySQL AB)¿ª·¢£¬²»ÓÃÔÙ¶à˵Á˰ɡ£
µ±ÎÒÃǰ´ÕÕÔÀ´µÄ·½Ê½Í¨¹ýPHP´æÈ¡MySQLÊý¾Ý¿âʱ£¬¾ÍËãÉèÖÃÁ˱íµÄĬÈÏ×Ö·û¼¯Îªutf8²¢ÇÒͨ¹ýUTF-8±àÂë·¢ËͲéѯ£¬Äã»á·¢ÏÖ´æÈëÊý¾Ý¿âµÄÈÔÈ»ÊÇÂÒÂë¡£ÎÊÌâ¾Í³öÔÚÕâ¸öconnectionÁ¬½Ó²ãÉÏ¡£½â¾ö·½·¨ÊÇÔÚ·¢ËͲéѯǰִÐÐÒ»ÏÂÏÂÃæÕâ¾ä£º
SET NAMES ‘utf8′;
ËüÏ൱ÓÚÏÂÃæµÄÈý¾äÖ¸Á
SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;
ÔÙÊÔÊÔ¿´£¬Õý³£Á˰
Ïà¹ØÎĵµ£º
¼ÇÁËһЩÓà Windows µÄÃüÁîÐÐÀ´²Ù×÷ MySQL µÄÖ¸Áî¡£
ÕªÒª
Á¬½á MySQL
->mysql -u username -p
username ÊÇÄãµÄÕʺÅÃû³Æ¡£
Ô¶³ÌÁ¬½á
->mysql -h hostname -u username -p
hostname ÊÇ MySQL Ö÷»úµÄÃû³Æ¡£
ÏÔʾȫ²¿µÄÊý¾Ý¿â
SHOW DATABASES;
mysql ÊÇ MySQL ÓÃÀ´´¢´æÕʺźÍȨÏÞµÄÊý¾Ý¿â£¬²»ÄÜɾ³ý¡£
Ñ¡Ôñ ......
MYSQLÓжàÖÖ´æ´¢ÒýÇæºÍ±íÀàÐÍ£¬InnoDBºÍBDBÖ§³ÖÊÂÎñ£¬Èç¹ûҪʹÓÃÊÂÎñ£¬±íµÄÀàÐ;ÍÓ¦¸ÃÊÇInnoDB.
Ìá¸ß±íµÄÐÔÄÜ£º
1¡¢ÓÃ×îСµÄÊý¾ÝÀàÐÍ¡£Õ¼ÓÿռäС£¬½ÚÊ¡´ÅÅ̿ռäºÍÄÚ´æ¡£
2¡¢±í¸ñµÄÖ÷Ë÷ÒýÒª¾¡¿ÉÄܵĶ̣¬ÒÔÃ÷ÏÔÌá¸ßЧÂÊ¡£
3¡¢Ë÷Òý×îºÃ½¨ÔÚΨһµÄÁÐÉÏ£¬Ë÷ÒýÔ½¶Ì£¬ËÙ¶ÈÔ½¿ì¡£
4¡¢¶àÁÐË÷Òý±ØÐë°üº¬×î×ó±ßµÄǰ׺²ÅÓÐЧ¡£ ......
æµµÄ2009ÖÕÓÚ¹ýÈ¥£¬Ò²ÖÕÓÚ°ÑÈËÉú´óÊÂæÍêÁË£¬»Øµ½Õý³£µÄ¹¤×÷Éú»îÖÐÀ´¡£2010¶ÔÎÒÀ´ËµÓ¦¸ÃÊdzäÂúÐÂÆÚÍûµÄÒ»Ä꣬ÐÂµÄÆõ»ú¾ÍÔÚÑÛǰ£¬¼ÓÓÍŬÁ¦°É~
ÁíÍâ×¼±¸12¸öÔÂÖ®ºóÔÙÀ´×ܽáһϽñÄêµÄÖØ´óʼǣ¬ºÇºÇ~
˳±ã¿´µ½Ò»¸öMysqlµÄ²âÊÔÎÄÕ£¬¸Ð¾õ»¹ÂúÓвο¼¼ÛÖµµÄ£¬ÓÚÊǼǼÏÂÀ´ÒÔ±ã²Î¿¼¡£
ÒÔÏÂÊÇÒ»¸öMySQLÖÐMyISAMÒýÇæÓëInnoDBÒ ......
Tomcat ÏÂ×îÈÝÒ×µ½µÄÎÊÌâ¾ÍÊÇÖÐÎÄÂÒÂëÎÊÌâÁË , ÏÂÃæ¾ÍÀ´Ì¸Ì¸ÎÒÔÚ Windows +Tomcat5 ϵ÷ÊÔ JSP ³ÌÐòʱ , ËùÅöµ½µÄÎÊÌâÒÔ¼°½â¾ö°ì·¨¡£
Õâ´Îµ÷ÊÔËùÓöµ½µÄÂÒÂëÎÊÌâÖ÷ÒªÓÐÈýÀࣺ
Ò»¡¢ Ò³Ãæ×Ö·ûÂÒÂë¡£
¼´Õû¸öÒ³Ãæ³öÏÖºº×ÖÂÒ ......
<?php
/*
* Ãû³Æ : MySQLÊý¾Ý¿â»ù±¾²Ù×÷
* ×÷Õß : pjx
* °æ±¾ : v 2010/02/25 v 1.0
* ˵Ã÷ : ¸ÃÀàÓÃÓÚ¶ÔMySQL×öһЩ¼òµ¥µÄ²Ù×÷
* ʾÀý £º
* ʵÀý => $db = new DB_MYSQL($database),´ò¸ö$databaseÊý¾Ý¿â
* ²éѯÊý¾Ý¿â => $db->query($sql_str),²éѯ$sql_st ......