ºÇ½ª¹¹¿·¡§ clever_next 2012ǯ07·î27Æü(¶â) 13:50:19ÍúÎò
utf8_general_ci¤Èutf8_unicode_ci¤Î°ã¤¤¤Ï¼ç¤Ë°Ê²¼¡£
¤Á¤Ê¤ß¤ËÁ´¤Æ¤ò¶èÊ̤·¤¿¤¤¾ì¹ç¤Ïutf8_bin¤ò»ÈÍѤ¹¤ì¤Ð¤è¤¤¡£
utf8_unicode_ci¤ÎƱ°ì»ëʸ»ú¤Ï¡¢strings/ctype-uca.c ¤ÇÄêµÁ¤µ¤ì¤Æ¤¤¤ë¡£
http://d.hatena.ne.jp/end0tknr/20100613/1276427626
MySQL 5.5.11 unicode_ci ¤ÇƱ°ì»ë¤µ¤ì¤ëʸ»ú
http://tmtm.org/tmp/mysql_unicode_collation.html
°Ê²¼¸¡¾Ú·ë²Ì
- utf8_general_ci
- ±Ñ»ú¤ÎÂçʸ»ú¾®Ê¸»ú¤Ï¶èÊ̤·¤Ê¤¤¡£
- Á´³ÑȾ³Ñ¤Ï¶èÊ̤¹¤ë¡£
- utf8_unicode_ci
- ±Ñ»ú¤ÎÂçʸ»ú¾®Ê¸»ú¤Ï¶èÊ̤·¤Ê¤¤¡£
- Á´³ÑȾ³Ñ¤â¶èÊ̤·¤Ê¤¤¡£
- ¤µ¤é¤ËÂù²»¡¢È¾Âù²»¡¢¤Ò¤é¤¬¤Ê¡¢¥«¥¿¥«¥Ê¤â¶èÊ̤·¤Ê¤¤¡£
- ¡Ö¤Ï¡×¤Ç¸¡º÷¤¹¤ë¤È¡Ö¤Ï¡×¡Ö¤Ð¡×¡Ö¤Ñ¡×¡Ö¥Ï¡×¡Ö¥Ð¡×¡Ö¥Ñ¡×¡ÖŽÊ¡×¤¬¥Ò¥Ã¥È¤¹¤ë¡£
¤Á¤Ê¤ß¤ËÁ´¤Æ¤ò¶èÊ̤·¤¿¤¤¾ì¹ç¤Ïutf8_bin¤ò»ÈÍѤ¹¤ì¤Ð¤è¤¤¡£
- Íî¤È¤··ê
utf8_unicode_ci¤ÎƱ°ì»ëʸ»ú¤Ï¡¢strings/ctype-uca.c ¤ÇÄêµÁ¤µ¤ì¤Æ¤¤¤ë¡£
http://d.hatena.ne.jp/end0tknr/20100613/1276427626
MySQL 5.5.11 unicode_ci ¤ÇƱ°ì»ë¤µ¤ì¤ëʸ»ú
http://tmtm.org/tmp/mysql_unicode_collation.html
°Ê²¼¸¡¾Ú·ë²Ì
utf8_general_ci
mysql> select general from charaset_test where general = '1'; +---------+ | general | +---------+ | 1 | +---------+ 1 row in set (0.00 sec)utf8_unicode_ci
mysql> select unicode from charaset_test where unicode = '1'; +---------+ | unicode | +---------+ | 1 | | £± | | ¡ | +---------+ 3 rows in set (0.00 sec)
utf8_general_ci
mysql> select general from charaset_test where general = 'a'; +---------+ | general | +---------+ | a | | A | +---------+ 2 rows in set (0.00 sec)utf8_unicode_ci
mysql> select unicode from charaset_test where unicode = 'a'; +---------+ | unicode | +---------+ | a | | A | | £á | | £Á | +---------+ 4 rows in set (0.00 sec)
utf8_general_ci
mysql> select general from charaset_test where general = '¤Ï'; +---------+ | general | +---------+ | ¤Ï | +---------+ 1 row in set (0.00 sec)utf8_unicode_ci
mysql> select unicode from charaset_test where unicode = '¤Ï'; +---------+ | unicode | +---------+ | ¤Ï | | ¤Ð | | ¤Ñ | | ¥Ï | | ¥Ð | | ¥Ñ | | ŽÊ | | ŽÊŽÞ | | ŽÊŽß | +---------+ 9 rows in set (0.00 sec)
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
WyDL7u Say, you got a nice blog. Really Great.