mysql utf 8 ÂÒÂë½â¾ö======ÕýÈ·µÄ
mysql utf-8 ÂÒÂë½â¾ö
Êý¾Ý¿â 2009-09-15 12:34:33 ÔĶÁ327 ÆÀÂÛ0 ×ֺţº´óÖÐС
ÔÚÍøÉÏ¿´¹ýºÜ¶à½â¾ömysqlÂÒÂëµÄÌû×Ó£¬¿ÉÊÇдµÄ²»ÊÇÂÞÀïÂÞà¾͹ýÓÚ¸´ÔÓ¡£ÆäʵÂÒÂëûÄÇô¸´ÔÓ£¬ÊÇÍøÉϵĴóÏÀÃÇÏë¶àÁË¡£ÎÒÑо¿¹ýÒ»¶ÎÈÕ×Ó£¬×ܽá³öÒ»Ì××Ô¼ºµÄ½â¾ö·½°¸£¬Èç¹ûÄ㻹û½â¾öÂÒÂë¾ÍÓÃÎҵķ½·¨ÊÔһϡ£Îҵķ½°¸²»ÊÇ×îºÃµÄ£¬È´ÊÇ×î¼òµ¥Ò׶®µÄ¡£²»ÐÅÄãÊÔÊÔ¡£
ÔÚʹÓÃMYSQLʱ£¬²åÈëÖÐÎÄ×Ö·û£¬¾³£»á³öÏÖÂÒÂ룬ÖÐÎÄÈ«±»ÓÃ?´úÌæ¡£³öÏÖÕâÖÖÇé¿öµÄÔÒò£¬¶àÊÇ×Ö·û¼¯²»Æ¥ÅäÔì³ÉµÄ¡£
ÔÚMYSQLÖУ¬Èç¹ûʹÓÃȱʡµÄ×Ö·û¼¯£¬ÔÚ½¨¿â¡¢½¨±íʱ£¬Ä¬ÈÏʹÓõÄÊÇlatin1×Ö·û¼¯£¬ÎªISO 8859-1Î÷Å·×Ö·û¼¯¡£²åÈëÖÐÎÄ×Ö·ûʱ£¬ÓëÖ®²»Æ¥Å䣬¾Í»á³öÏÖÂÒÂë¡£
Òª½â¾ö´ËÎÊÌ⣬¾Í±ØÐëÊÖ¶¯½«Êý¾Ý¿âServerºÍClientµÄ×Ö·û±àÂë¸ÄΪgb2312¡£ÅäÖ÷½·¨ÈçÏ£º
´ò¿ªMYSQL°²×°Ä¿Â¼ÏµÄmy.iniÎļþ£¬ÕÒµ½Èç϶ÎÂ䣺
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=latin1
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/MySQL/MySQL Server 5.0/"
#Path to the database root
datadir="D:/MySQL/MySQL Server 5.0/Data/"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
½«ÆäÖеÄdefault-character-set=latin1¸ÄΪdefault-character-set=gb2312( Á½¸ö¶¼¸Ä),È»ºóÖØÆôMYSQL(Ìرð×¢Ò⣺ÒÔÇ°½¨Á¢µÄÊý¾Ý¿âÒªÖؽ¨£¬ÒòΪÒÔÇ°´æ´¢µÄÊý¾Ý±àÂë·
Ïà¹ØÎĵµ£º
ĬÈÏÇé¿öÏ£¬innodbµÄ²ÎÊýÉèÖõķdz£Ð¡£¬ÔÚÉú²ú»·¾³ÖÐÔ¶Ô¶²»¹»ÓÃ
±ÈÈç×îÖØÒªµÄÁ½¸ö²ÎÊý
innodb_buffer_pool_size
ĬÈÏÊÇ8M
innodb_flush_logs_at_trx_commit ĬÈÏÉèÖõÄÊÇ1 Ò²¾ÍÊÇͬ²½Ë¢ÐÂlog(¿ÉÒÔÕâôÀí½â)
innodb_buffer_pool_size£º
ÕâÊÇInnoDB×îÖØÒªµÄÉèÖ㬶ÔInnoDBÐÔÄÜÓоö¶¨ÐÔµÄÓ°Ï졣ĬÈϵÄÉèÖÃÖ»ÓÐ8M£¬ËùÒÔ ......
MySQL½¨Á¢ÁÙʱ±íµÄÓï¾äÈçÏÂ:
CREATE TEMPORARY TABLE tmp (
article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,
price DOUBLE(16,2) DEFAULT '0.00' NOT NULL);
--LOCK TABLES article read;
--ÏȲåÈëÊý¾Ýµ½ÁÙʱ±í
INSERT INTO tmp SELECT article, MAX(price) from shop GRO ......
˵Ã÷: ÔÚMYSQLÖУ¬Èç¹ûʹÓÃȱʡµÄ×Ö·û¼¯£¬ÔÚ½¨¿â¡¢½¨±íʱ£¬Ä¬ÈÏʹÓõÄÊÇlatin1×Ö·û¼¯£¬
ΪISO 8859-1Î÷Å·×Ö·û¼¯¡£²åÈëÖÐÎÄ×Ö·ûʱ£¬ÓëÖ®²»Æ¥Å䣬¾Í»á³öÏÖÂÒÂë¡£
¡¾½â¾ö·½°¸¡¿
1. ´ò¿ªÎļþ: C:\Program Files\MySQL\MySQL Server 5.0\my.ini;
2. ½«ÆäÖеÄdefault-character-set=latin1¸ÄΪdefault-character-set=gb2312,
......
½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢
¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢
Ò³ÃæÖ®¼ä´«µÝµÄ²Î ......
ËùÓеÄÊýѧº¯ÊýÔÚÒ»¸ö³ö´íµÄÇé¿öÏ·µ»ØNULL¡£
-
µ¥Ä¿¼õ¡£¸Ä±ä²ÎÊýµÄ·ûºÅ¡£
mysql> select - 2;
×¢Ò⣬Èç¹ûÕâ¸ö²Ù×÷·ûÓëÒ»¸öBIGINTʹÓ㬷µ»ØÖµÊÇÒ»¸öBIGINT£¡ÕâÒâζ×ÅÄãÓ¦¸Ã±ÜÃâÔÚÕûÊýÉÏʹÓÃ-£¬ÄÇ¿ÉÄÜÓÐÖµ-2^63£¡
ABS(X)
·µ»ØXµÄ¾ø¶ÔÖµ¡£
mysql ......