[B! utf8] TokyoIncidentsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

TokyoIncidents id:TokyoIncidents

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

utf8ã«é–¢ã™ã‚‹TokyoIncidentsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

MySQLã«çµµæ–‡å—ã‚’æ ¼ç´ã™ã‚‹ã«ã¯utf8mb4ã‚’ä½¿ã†å¿…è¦ãŒã‚ã£ãŸ - F.Ko-Jiã®ã€Œä¸€ç§’å¾Œã¯æœªæ¥ã€
ä¸€ä½“ä½•å¹´å‰ã®è©±ã‚’ã—ã¦ã‚‹ã‚“ã ã¨æ€ã‚ã‚Œãã†ã§ã™ãŒã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ãªã©ã§å…¥åŠ›ã§ãã‚‹çµµæ–‡å—ã‚’ MySQL ã«ãã¡ã‚“ã¨æ ¼ç´ã™ã‚‹ã«ã¯ UTF-8 ã§ã¯ãªã utf8mb4 ã¨ã„ã†æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’ä½¿ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ MySQL 5.5.3 ä»¥é™ã§ä½¿ãˆã¾ã™ã€‚ Â» MySQL :: MySQL 5.5 Reference Manual :: 10.1.10.6 The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding) è‡ªåˆ†ãŒã»ã¨ã‚“ã©çµµæ–‡å—ã‚’ä½¿ã‚ãªã„ã®ã§ã¾ã£ãŸãè€ƒæ…®ã—ã¦ãªã‹ã£ãŸã®ã§ã™ãŒã€ã€Œ#ã‚°ãƒ©ãƒ‰ãƒ«è‡ªç”»æ’®ã‚Šéƒ¨ ã®éƒ¨å®¤ã€ã§ Twitter ã‹ã‚‰å–ã‚Šè¾¼ã‚“ã ãƒ„ã‚¤ãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã¦ã¿ã‚‹ã¨ã€ãƒ„ã‚¤ãƒ¼ãƒˆã®æ–‡ç« ãŒé€”ä¸ã§åˆ‡ã‚Œã¦ã—ã¾ã£ã¦ã„ã‚‹ã‚‚ã®ãŒçµæ§‹ãŸãã•ã‚“ã‚ã‚Šã¾ã—ãŸã€‚ â†‘ ã»ã‚“ã¨ã¯æœ€å¾Œã«ãƒãƒƒã‚·ãƒ¥ã‚¿ã‚°ã‚„ç”»åƒã® URL ãŒã¤ã„ã¦ã„ã‚‹ã¯ãšã€‚ èª¿ã¹ã¦ã¿ã‚‹ã¨çµµæ–‡å—ã®ã¨
TokyoIncidents 2014/11/17
utf8
ãƒªãƒ³ã‚¯
Route 477(2013-04-01)
â– [ruby] Rubyã§UTF8-MACã‚’UTF-8ã«ç›´ã™ ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼.appã‹ã‚‰Mac Vimã«ã‚³ãƒ”ãƒšã—ãŸã‚‰ã€ã€Œã¯ã˜ã‚ã«ã€ãŒã€Œã¯ã—ã‚›ã‚ã«ã€ã¿ãŸã„ã«ãªã£ã¦ã—ã¾ã£ã¦å›°ã£ãŸã®ã§ã€ Rubyã®ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠã§ç›´ã—ã¦ã¿ãŸã€‚ $ ruby -e 'print File.read(ARGV[0], encoding: "utf8-mac").encode("utf-8")' a.txt > b.txt Ruby(>= 1.9)ä¾¿åˆ©ã€‚ â– [ruby] Rubyã§Magic commentãŒå¿…è¦ãªãƒ•ã‚¡ã‚¤ãƒ«ã‚’åˆ—æŒ™ã™ã‚‹ Ruby 2.0ã‹ã‚‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒUTF-8ã«ãªã£ãŸã®ã§ã€æ–‡å—åˆ—ãƒªãƒ†ãƒ©ãƒ«ã«æ—¥æœ¬èªžã‚’ä½¿ã†ã¨ãã‚‚ãƒžã‚¸ãƒƒã‚¯ã‚³ãƒ¡ãƒ³ãƒˆã‚’æ›¸ã‹ãªãã¦è‰¯ããªã‚Šã¾ã—ãŸã€‚ â€¦ã¨ã„ã†ã®ã¯å¬‰ã—ã„å¤‰æ›´ãªã‚“ã§ã™ãŒã€ãã†ã™ã‚‹ã¨ä»Šåº¦ã¯ã€Œæ‰‹å…ƒã®Ruby 2.0ã§ã¯å‹•ã„ã¦ã‚‹ã‘ã©ã€ã‚µãƒ¼ãƒã®Ruby 1.9.3ã§å‹•ã‹ã—ãŸ
TokyoIncidents 2013/04/25
ruby

utf8
ãƒªãƒ³ã‚¯
URIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«utf8ãƒ•ãƒ©ã‚°ã¤ãã®æ–‡å—åˆ—ã‚’é£Ÿã‚ã›ãŸã‚‰query_formã®ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ãŒåŒ–ã‘ãŸã§ã”ã–ã‚‹ã®å·» - ã¨ã‚ã‚‹ãƒ¢ãƒã‚¤ãƒ«ç³»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ—¥ã€…
ã‚¿ã‚¤ãƒˆãƒ«é•·ã„ã€‚ã£ã¦ã„ã†ã‹ãã®ã¾ã‚“ã¾ã§ã™ã€‚ #!/usr/bin/perl use strict; use warnings; use URI; my $s = 'http://example.com/?q=%82%e2%82%e9%95v%82%c5%8aw%82%d4'; utf8::upgrade($s); my $uri = URI->new($s); my %qf = $uri->query_form; $qf{flag} = 'ON'; $uri->query_form( %qf ); my $uri_str = $uri->as_string; ã“ã‚Œã€ä¸€è¦‹ã™ã‚‹ã¨$uri_strã¯ http://example.com/?q=%82%e2%82%e9%95v%82%c5%8aw%82%d4&flag=ONã«ãªã‚Šãã†ãªã‚“ã§ã™ãŒã€å®Ÿéš›ã«ã¯ http://example.com/?q=
TokyoIncidents 2010/09/25
perl

utf8
ãƒªãƒ³ã‚¯
PHPã¨MySQLã®å€‹äººçš„ã¾ã¨ã‚ - ã±ã‚“ã´ãƒ¼ã¾ã£ã—ãã‚‰
MySQLã§ã¯ã¾ã£ãŸã“ã¨ MySQLã®æ–‡å—åŒ–ã‘ ä»Šã•ã‚‰ä½•ã„ã£ã¦ã‚“ã®ã‚³ã‚¤ãƒ„ã¨ã‹ãã“è¨€ã‚ãªã„ã€‚ æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’ç¢ºèªã™ã‚‹SQLæ–‡ã€ŒSHOW VARIABLES LIKE â€˜char%â€™;ã€ MySQL4.1ä»¥é™ã¯ã‚µãƒ¼ãƒã¨ã¯åˆ¥ã«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€ã‚µãƒ¼ãƒé–“ã§é•ã†æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒã‚»ãƒƒãƒˆã•ã‚Œã¦ã„ã‚‹ã¨ã€ä¸€åº¦ucs2å¤‰æ›ã‚’é€šã‚‹ã€‚ ã‚ˆã£ã¦ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€ã‚µãƒ¼ãƒé–“ã§é•ã†æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã¨ãªã‚Šæ–‡å—åŒ–ã‘ãŒèµ·ã“ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ PHPã¯my.cnfã§[mysql]ã€[client]ã‚’è¨å®šã—ã‚ˆã†ãŒã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ãƒ“ãƒ«ãƒ‰æ™‚ã«æŒ‡å®šã•ã‚ŒãŸã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆ(é€šå¸¸latin1)ã€‚ my.cnfã®è¨å®š [mysql] default-character-set = utf8 [mysqld] default-character-set = utf8 mysqlã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ãƒã‚§
TokyoIncidents 2010/09/25
php

mysql

utf8
ãƒªãƒ³ã‚¯
#perl - utf8::decode()ã§ã¯ãªãEncode::decode_utf8()ã‚’ä½¿ã†ã¹ãç†ç”± : 404 Blog Not Found
2009å¹´09æœˆ13æ—¥13:00 ã‚«ãƒ†ã‚´ãƒªLightweight Languages #perl - utf8::decode()ã§ã¯ãªãEncode::decode_utf8()ã‚’ä½¿ã†ã¹ãç†ç”± é§„ç›®ã§ã™ã€‚ [ã‚’] Perl ã® utf8 ã¾ã‚ã‚Šã®ãŠã¾ã˜ãªã„ æœ€è¿‘è‰¯ãä½¿ã†ãŠã¾ã˜ãªã„ã€ã¨ã„ã†ã‹ã‚¤ãƒ‡ã‚£ã‚ªãƒ ã€‚ utf8::decode($text) unless utf8::is_utf8($text); ã“ã†ã„ã†å ´åˆã¯ã€Encode::decode_utf8()ã§ãªã„ã¨ã€‚ ä»¥ä¸‹ã‚’ã”ã‚‰ã‚“ãã ã•ã„ã€‚ #!/usr/bin/perl use strict; use warnings; use Encode; use Devel::Peek; for my $bytes ( "\x2F", "\xC0\xAF", "\xE0\x80\xAF", "\xF0\x80\x80\xAF" ) { my $u
TokyoIncidents 2009/09/14
perl

dankogai

encode

utf8
ãƒªãƒ³ã‚¯
1