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

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%';
+--------------------------+----------------------------+
| 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 | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
2£¬
a) ÉèÖÃwebÈÝÆ÷µÄ±àÂë¸ñʽ¡£ÎªÄãµÄservletµÄdoGet»òdoPost·½·¨¿ªÊ¼´¦¼ÓÈëÈçÏ´úÂ룺
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
b) Ϊÿ¸öjspÒ³ÃæÖ¸¶¨Æä±àÂë¸ñʽ¡£<%@ page pageEncoding="utf-8"%>
c) ÔÚÁ¬½ÓÊý¾Ý¿âÓõÄURLºó¼ÓÈ룺useUnicode=true;characterEncoding=utf-8¡¡È磺
¡¡¡¡                      url="jdbc:mysql:///db1?useUnicode=true&characterEncoding=utf-8"£¬
Èç¹ûÊÇxmlÎļþÖР    url="jdbc:mysql:///db1?useUnicode=true&amp;characterEncoding=utf-8"£¬
3, 
Èç¹û»¹³öÏÖÂÒÂ룬ÔòÓпÉÄÜÊÇ ±íÖеÄ×ֶΠµÄ±àÂë²»ÊÇutf-8;
Èç¹û³öÏÖÂÒÂëµÄ±íÊÇ book
mysql> show create table book;
+--------------------------+----------------------------+ 
 | Table | Create Table|
+--------------------------+----------------------------+
|book | create table 'book'(
     'id'  int(10) unsigned NOT NULL AUTO_INCREMENT,
     'bookname'  varchar(45)  CHARACTER SET latin1 NOT NULL,
     'source'  varc


Ïà¹ØÎĵµ£º

MySQLÖеÄÒ»¸öÄÑÌâ

×òÌ죬ÎÒͻȻÏë°ÑÒ»¸öÊý¾Ý¿âÀïµÄÿ¸ö±í£¬ÒÔ¼°Ã¿¸ö±íµÄ·Ç¿Õ×ܼͼÊý´æÔÚÁíÒ»¸ö±íÀïÃæ¡£
Ê×ÏÈ£¬´´½¨ÁËÒ»¸ö´æ·ÅÊý¾ÝµÄ±í£º
create table tables
(
name varchar(50),
number int
);
insert into tables select table_name from information_schema.tables where table_shema = 'test';
µ«ÊDz»ÖªµÀÓÐûÓз½·¨£¬½«·Ç¿ÕµÄ ......

¼Ç¼µã¶«Î÷£¬MSSQL£¬MySQL£¬.NETµÄMD5¼ÓÃÜ

 MSSQL:select Right(sys.fn_VarBinToHexStr(hashbytes('MD5', '123456')),32)
 MSSQL16λ:select Right(sys.fn_VarBinToHexStr(hashbytes('MD5', '123456')),16)
 MySQL:select md5('123456')
 .NET:string ½á¹û×Ö·û´®=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFil ......

¸ü¸ÄMySqlÊý¾Ý¿âµÄĬÈϱàÂë¸ñʽ

Ò»¡¢ÉèÖÃÊý¾Ý¿â±àÂë
°²×°mysqlʱ¿ÉÑ¡Ôñ±àÂ룬Èç¹ûÒѾ­°²×°¹ý£¬¿ÉÒÔ¸ü¸ÄÎļþmy.ini(´ËÎļþÔÚmysqlµÄ°²×°Ä¿Â¼ÏÂ)ÖеÄÅäÖÆÒԴﵽĿµÄ£»´ò¿ªÎļþÕÒµ½Á½´¦£º
[client]
port=3306
[mysql]
default-character-set=gb2312
# The default character set that will be used when a new
schema or table is
# created and
n ......

MySql ×ܽá

1.´ÓWindowsÃüÁîÐÐÆô¶¯MySQL
ÒªÏë´ÓÃüÁîÐÐÆô¶¯mysqld·þÎñÆ÷£¬ÄúÓ¦µ±Æô¶¯¿ØÖÆ̨´°¿Ú(»ò“DOS window”)²¢ÊäÈëÃüÁ
¡¡¡¡C£º\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld
¡¡¡¡¸ù¾ÝϵͳÖÐMySQL°²×°Î»ÖõIJ»Í¬£¬Ç°ÃæµÄÀý×ÓÖÐʹÓõÄ·¾¶Ò²²»Í¬¡£
¡¡¡¡ÔÚ·ÇNT°æ±¾µÄWindowsÖУ¬ÔÚºǫ́Æô¶¯mysqld¡£Ò² ......

MySQL ×Ö·û¼¯µ¼ÖÂSQLÁ¬½ÓÖ®ºóÖÐÎÄÂÒÂëµÄÎÊÌ⣡

character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ