{"type":"rich","provider_url":"https://hatena.blog","url":"https://blog.kyanny.me/entry/20080311/1205207468","blog_title":"@kyanny's blog","image_url":null,"height":"190","provider_name":"Hatena Blog","description":"Perl \u3067 Encode \u3067\u3069\u3046\u305f\u3089\u3001\u3068\u3044\u3046\u306e\u306e\u7d9a\u304d\u3067\u3059\u3002\u524d\u306e\u30a8\u30f3\u30c8\u30ea\u3092\u304b\u304d\u306a\u304c\u3089\u3001\u81ea\u5206\u304c\u3057\u305f\u3044\u3053\u3068\u3092\u3046\u307e\u304f\u8a00\u3044\u8868\u305b\u3066\u306a\u3044\u306a\u3001\u3068\u3082\u3084\u3082\u3084\u3057\u3066\u3044\u3066\u3001\u300c\u3053\u3046\u3059\u308c\u3070\u3088\u3044\u300d\u3068\u30a2\u30c9\u30d0\u30a4\u30b9\u3092\u3044\u305f\u3060\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u305d\u308c\u3092\u8a66\u3057\u3066\u307f\u3066\u3082\u610f\u56f3\u3057\u305f\u3088\u3046\u306a\u7d50\u679c\u304c\u5f97\u3089\u308c\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u81ea\u5206\u304c\u3053\u3053\u307e\u3067\u7406\u89e3\u3057\u3066\u3044\u308b\u3053\u3068\u306f\u3001 MySQL-5.0 (4.1 \u4ee5\u964d\u304b) \u3067\u306f\u30c6\u30fc\u30d6\u30eb\u3054\u3068\u3001\u30ab\u30e9\u30e0\u3054\u3068\u306b character_set \u3092\u6307\u5b9a\u3067\u304d\u308b SELECT \u3059\u308b\u3068\u304d\u306b\u3001 character_set \u3068\u95a2\u9023\u304c\u3042\u308b collation \u3068\u3044\u3046\u6bd4\u8f03\u6761\u4ef6\u3092\u4f7f\u3063\u3066\u3001 WHERE \u53e5\u306e\u691c\u7d22\u6761\u4ef6\u3068\u3057\u3066\u4e0e\u3048\u3089\u308c\u305f\u6587\u5b57\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u30c7\u30fc\u30bf\u3092\u6bd4\u8f03\u3059\u2026","author_name":"a666666","title":"Encode \u3067\u306f\u554f\u984c\u306a\u304f decode \u3067\u304d\u308b\u306e\u306b MySQL \u306b INSERT \u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001\u3067\u304d\u306a\u3044\u30c7\u30fc\u30bf","author_url":"https://blog.hatena.ne.jp/a666666/","blog_url":"https://blog.kyanny.me/","version":"1.0","width":"100%","published":"2008-03-11 12:51:08","categories":["Perl"],"html":""}