É¢·Ö£¬mysqlÖÐÓйØ~·ûºÅÔõôÓã¿
Çë¹ý·ÅóÓѸøµã~·ûºÅµÄʵÀý£¬Ï×ÉÏ50·Ö¡£
·´×ªËùÓбÈÌØ¡£
mysql> SELECT 5 & ~1;
-> 4
ÎÒÖªµÀÊÇתÒâµÄÒâ˼£¬ÎÒÊÇÔÚÍøÉÏÕÒmysqlÔõÑù½«Ò»¾ä´øÓе¥ÒýºÅµÄÓï¾äÊä½øÊý¾Ý¿â£¬È»ºóÓÐÈË˵ÓÃ~תÒ⣬µ«ÎÒ²¢²»ÖªµÀ~Ôõôת£¬ËùÒÔÏëÎÊÏÂ~תÒâµÄÓ÷¨£¬²¢²»ÊÇ·´±ÈÌØµÄÒâ˼¡£
Òª°Ñµ¥ÒýºÅ²åÈëÊý¾Ý¿âÖÐ,ÓÃÁ½¸öµ¥ÒýºÅ¾Í¿ÉÒÔÁË¡£
SQL code:
mysql> select * from test;
Empty set (0.00 sec)
mysql> insert into test values('''');
Query OK, 1 row affected (0.03 sec)
mysql> select * from test;
+------+
| str |
+------+
| ' |
+------+
1 row in set (0.00 sec)
ʹÓÃ\'תÒå¼´¿É¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......