{"id":6583,"date":"2011-05-04T08:00:40","date_gmt":"2011-05-03T23:00:40","guid":{"rendered":"http:\/\/www.sssg.org\/blogs\/hiro345\/?p=6583"},"modified":"2011-04-29T18:34:36","modified_gmt":"2011-04-29T09:34:36","slug":"mysql%e3%81%a7%e6%96%87%e5%ad%97%e5%8c%96%e3%81%91%e3%81%ab%e5%87%ba%e4%bc%9a%e3%81%a3%e3%81%9f%e3%82%89","status":"publish","type":"post","link":"https:\/\/www.hiro345.net\/blogs\/hiro345\/archives\/6583.html","title":{"rendered":"MySQL\u3067\u6587\u5b57\u5316\u3051\u306b\u51fa\u4f1a\u3063\u305f\u3089"},"content":{"rendered":"

MySQL\u3067\u6587\u5b57\u5316\u3051\u306b\u51fa\u4f1a\u3063\u305f\u3089\u3001MySQL\u306e\u8a2d\u5b9a\u3092\u78ba\u8a8d\u3059\u308b\u306e\u304c\u4e00\u756a\u3067\u3059\u3002
\n<\/p>\n

\u3044\u304f\u3064\u304b\u3042\u308b\u65b9\u6cd5\u306e\u4e2d\u3067\u3082\u3001\u76f4\u63a5\u7684\u306a\u65b9\u6cd5\u3068\u3057\u3066\u3001hex()\u3092\u4f7f\u3046\u65b9\u6cd5\u3092\u77e5\u308a\u307e\u3057\u305f\u3002\u4f8b\u3048\u3070\u3001\u6b21\u306e\u3088\u3046\u306b\u300c\u30d6\u30ed\u30b0\u300d\u3068\u3044\u3046\u5024\u3092\u6301\u3064\u30ab\u30e9\u30e0 blog_name \u304c\u3042\u3063\u305f\u3089\u3001\u3053\u308c\u3092hex()\u3067\u5909\u63db\u3057\u3066\u307f\u308c\u3070\u3088\u3044\u3088\u3046\u3067\u3059\u3002\u304d\u3061\u3093\u3068\u52d5\u4f5c\u3057\u3066\u3044\u308b\u74b0\u5883\u3067\u3001hex(‘\u30d6\u30ed\u30b0’) \u3068\u3057\u305f\u5834\u5408\u306e\u5024\u3068\u6bd4\u8f03\u3057\u3066\u3001\u3069\u3046\u306a\u3063\u3066\u3044\u308b\u304b\u307f\u308c\u3070\u3001\u30d2\u30f3\u30c8\u304c\u307f\u3048\u3066\u304f\u308b\u306f\u305a\u3002<\/p>\n

mysql> select blog_id, blog_name from mt_blog where blog_id=8;
\n+---------+-----------+
\n| blog_id | blog_name |
\n+---------+-----------+
\n|       8 | \u30d6\u30ed\u30b0    | 
\n+---------+-----------+
\n1 row in set (0.00 sec)<\/p>\n

mysql> select blog_id, hex(blog_name) from mt_blog where blog_id=8;
\n+---------+--------------------+
\n| blog_id | hex(blog_name)     |
\n+---------+--------------------+
\n|       8 | E38396E383ADE382B0 | 
\n+---------+--------------------+
\n1 row in set (0.00 sec)<\/p>\n

mysql> select hex('\u30d6\u30ed\u30b0');
\n+--------------------+
\n| hex('\u30d6\u30ed\u30b0')      |
\n+--------------------+
\n| E38396E383ADE382B0 | 
\n+--------------------+
\n1 row in set (0.00 sec)\n<\/p><\/div>\n

\u53c2\u8003\uff1a
\nMysql\u306e\u6587\u5b57\u30b3\u30fc\u30c9<\/a><\/p>\n

\u95a2\u9023\u66f8\u7c4d\uff1a
\n