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

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;
ÔÙÊÔÊÔ¿´£¬Õý³£Á˰


Ïà¹ØÎĵµ£º

sqliteºÍpdo mysqlµÄÊý¾Ý¿â²Ù×÷

½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......

MySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò

MySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò£º 
¡ô1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£ 
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º 
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< ......

mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ºÍ×Ö·û¼¯ÎÊÌâ

1.mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ÎÊÌâ
 
ÔÚʹÓÃmysql 5.0 Ö÷´ÓÊý¾Ý¿âͬ²½Ê±Óöµ½ÎÊÌâһЩÎÊÌ⣺
ÔÚÖ÷´ÓÊý¾Ý¿âͬ²½Ê±£¬ÎÒÃÇ¿ÉÄÜ»áÑ¡ÔñÄÄЩÊý¾Ý¿âÒªÇóͬ²½£¬¶øÄÇЩÊý¾Ý¿âºöÊÓ£¬ÕâÁ½¸ö¹¦ÄÜÊÇ¿¿/etc/my.cnfÎļþÖеÄÁ½¸ö¼üÃû binlog_do_db ºÍ binlog_ignore_db À´ÊµÏÖµÄ
binlog_do_db = ÌîдÐèҪͬ²½µÄÊý¾Ý¿â£¬¶à¸öÊý¾Ý¿âÔòÓÃ&lsqu ......

Tomcat5+MysqlÎÄÖÐÂÒÂëÎÊÌâµÄ½â¾ö·½·¨ (ת)


Tomcat ÏÂ×îÈÝÒ×µ½µÄÎÊÌâ¾ÍÊÇÖÐÎÄÂÒÂëÎÊÌâÁË , ÏÂÃæ¾ÍÀ´Ì¸Ì¸ÎÒÔÚ Windows +Tomcat5 Ïµ÷ÊÔ JSP ³ÌÐòʱ , ËùÅöµ½µÄÎÊÌâÒÔ¼°½â¾ö°ì·¨¡£
       Õâ´Îµ÷ÊÔËùÓöµ½µÄÂÒÂëÎÊÌâÖ÷ÒªÓÐÈýÀࣺ
Ò»¡¢ Ò³Ãæ×Ö·ûÂÒÂë¡£
¼´Õû¸öÒ³Ãæ³öÏÖºº×ÖÂÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ