[B! charset] perezvonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

perezvon id:perezvon

charsetã«é–¢ã™ã‚‹perezvonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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(InnoDB) ã§ "Index column size too large. The maximum column size is 767 bytes." ã„ã‚ã‚Œã‚‹ã¨ãã®å¯¾ç– - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
tl;dr: MySQL 5.5.14ä»¥é™ã ã¨innodb_large_prefixã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§3072ãƒã‚¤ãƒˆã¾ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å¼µã‚Œã‚‹ MySQL(InnoDB)ã§ã¯ã€ã²ã¨ã¤ã®ã‚«ãƒ©ãƒ ã®ã‚ãƒ¼ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã®æœ€å¤§å€¤ãŒ767ãƒã‚¤ãƒˆã¨ã„ã†åˆ¶é™ãŒã‚ã‚‹ã®ã§ã€ã¤ã„ã†ã£ã‹ã‚Šã—ã¦ Index column size too large. The maximum column size is 767 bytes. ã¨ã‹ Specified key was too long; max key length is 767 bytes ã¨ã„ã£ãŸã‚¨ãƒ©ãƒ¼ã‚’è¦‹ãŸã“ã¨ã‚ã‚‹äººã¯å¤šã„ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ ã‚ˆãã‚ã‚‹ã‚±ãƒ¼ã‚¹ã ã¨ã€varchar(256)ä»¥ä¸Šã®utf8ãªã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã‚ã†ã¨ã™ã‚‹ã¨ã“ã®ã‚¨ãƒ©ãƒ¼ã¨ã”å¯¾é¢ã§ãã¾ã™ã€‚ CREATE TABLE t (c varchar(256), index (c)); ERROR
perezvon 2013/04/18
utf8mb4

mysql

innodb

charset
ãƒªãƒ³ã‚¯
Haskellã§ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰å‘¨è¾º - Takaki's web
SJISã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ‰±ã†ã®ã«è‹¦åŠ´ã—ãŸã€‚é©å½“ã«ã‚„ã‚‹ã¨invalite byte sequenceã¨ã‚¨ãƒ©ãƒ¼åã‹ã‚Œã¦çµ‚äº†ã€‚ãã¡ã‚“ã¨å¤‰æ›ã—ãªã„ã¨ã„ã‘ãªã„ã€‚ import Codec.Text.IConv import Data.ByteString.Lazy.Char8 (pack, unpack) import qualified Data.ByteString.Lazy.Char8 as BS import Codec.Binary.UTF8.String inFile = "z_sjis.txt" main = do cs <- BS.readFile inFile let u8s = convert "CP932" "UTF-8" cs -- OK BS.putStr u8s putStr $ decodeString (unpack u8s) -- NG putStr (unpack u
perezvon 2013/02/13
haskell

charset

encoding
ãƒªãƒ³ã‚¯
EUC-JPã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã¨æˆ¦ã† - mzsmsã®é›‘è¨˜
webã‹ã‚‰htmlãƒ‡ãƒ¼ã‚¿ã‚’ã¨ã£ã¦Haskellã§è§£æžã—ã‚ˆã†ã¨ã—ãŸã®ã ã‘ã©ã€å¯¾è±¡ã®htmlãŒEUC-JPã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã§ãªã‹ãªã‹ã†ã¾ãã„ã‹ãªã„ã€‚ä»•æ–¹ãªã„ã®ã§ã€ wgetã‚’ä½¿ã£ãŸshellã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’Haskellãƒ—ãƒã‚°ãƒ©ãƒ ã§åãå‡ºã™ ãã®shellã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰èµ·å‹•ã—ã¦ã€ãƒ•ã‚¡ã‚¤ãƒ«ã«ä¿å˜ åŒæ™‚ã«shellã‚¹ã‚¯ãƒªãƒ—ãƒˆä¸ã§iconvã‚³ãƒžãƒ³ãƒ‰ã§UTF-8ã«å¤‰æ› ãƒ•ã‚¡ã‚¤ãƒ«ã‚’Haskellãƒ—ãƒã‚°ãƒ©ãƒ ã§é–‹ã„ã¦è§£æž ã¨ã„ã†æ‰‹é †ã‚’ã¨ã‚‹ã“ã¨ã«ã—ãŸã€‚ãã‚“ãªã“ã¨ã™ã‚‹ãã‚‰ã„ãªã‚‰ã€Pythonã¨ã‹Perlã§è‰¯ã„ã‚“ã˜ã‚ƒãï¼Ÿã€€ã¨ã„ã†æ°—ã‚‚ã—ãªã„ã§ã¯ãªã„ã‘ã©ã€ã“ã‚Œã§é †èª¿ã«å‹•ã„ã¦ã„ãŸã€‚ ã¨ã“ã‚ãŒã€æ–°ã—ãæ¬²ã—ããªã£ãŸhtmlãƒ‡ãƒ¼ã‚¿ã®URIãŒEUC-JPã§URIã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã•ã‚Œã¦ã„ã‚‹ã€‚ã“ã‚Œã«å›°ã£ãŸã€‚ã‚¦ã‚ãƒ¼ã¨ãªã£ãŸã€‚ çµå±€ã€URIã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’Haskellã§æ›¸ã„ã¦ã€ãã‚Œã‚’ä¸Šè¨˜shellã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ãªã‹ã§å‘¼ã³å‡ºã™ã“ã¨ã™
perezvon 2013/02/13
haskell

charset

encoding
ãƒªãƒ³ã‚¯
æ–‡å—ã‚³ãƒ¼ãƒ‰ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å•é¡Œã¯ã©ã†å¯¾ç–ã™ã¹ãã‹: U+00A5ã‚’ç”¨ã„ãŸXSSã®å¯èƒ½æ€§ - å¾³ä¸¸æµ©ã®æ—¥è¨˜(2009-03-11)
_U+00A5ã‚’ç”¨ã„ãŸXSSã®å¯èƒ½æ€§ å‰å›žã®æ—¥è¨˜ã§ã¯ã€æ˜¨å¹´ã®Black Hat Japanã«ãŠã‘ã‚‹é•·è°·å·é™½ä»‹æ°ã®è¬›æ¼”ã«ã€Œè¶£å‘³ã¨å®Ÿç›Šã®æ–‡å—ã‚³ãƒ¼ãƒ‰æ”»æ’ƒ(è¬›æ¼”è³‡æ–™)ã€ã«åˆºæ¿€ã•ã‚Œã‚‹å½¢ã§ã€Unicodeã®å††è¨˜å·U+00A5ã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å¯èƒ½æ€§ã«ã¤ã„ã¦æŒ‡æ‘˜ã—ãŸã€‚ ã¯ã›ãŒã‚æ°ã®å…ƒè³‡æ–™ã§ã¯ãƒ‘ã‚¹ãƒˆãƒ©ãƒãƒ¼ã‚µãƒ«ã®å¯èƒ½æ€§ã‚’æŒ‡æ‘˜ã—ã¦ãŠã‚‰ã‚Œã‚‹ã®ã§ã€æ®‹ã‚‹è„†å¼±æ€§ãƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã—ã¦ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆãƒ»ã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚°(XSS)ã®å¯èƒ½æ€§ãŒã‚ã‚‹ã‹ã©ã†ã‹ãŒãšã£ã¨æ°—ã«ãªã£ã¦ã„ãŸã€‚ç‹¬è‡ªã®èª¿æŸ»ã«ã‚ˆã‚Šã€XSSæ”»æ’ƒã®èµ·ç‚¹ã¨ãªã‚‹ã€Œ<ã€ã‚„ã€Œ"ã€ã€ã€Œ'ã€ãªã©ã«ã¤ã„ã¦ã€Œå¤šå¯¾ä¸€ã®å¤‰æ›ã€ãŒã•ã‚Œã‚‹æ–‡å—ã‚’æŽ¢ã—ã¦ããŸãŒã€ç¾å®Ÿçš„ãªWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§å‡ºç¾ã—ãã†ãªçµ„ã¿åˆã‚ã›ã¯è¦‹ã¤ã‘ã‚‰ã‚Œã¦ã„ãªã„ã€‚ ä¸€æ–¹ã€U+00A5ãŒå‡¦ç†ç³»ã«ã‚ˆã£ã¦ã¯0x5Cã€Œ\ã€ã«å¤‰æ›ã•ã‚Œã‚‹ã“ã¨ã«èµ·å› ã—ã¦XSSãŒç™ºç”Ÿã™ã‚‹å¯èƒ½æ€§ã¯ã‚ã‚‹ã€‚JavaScriptãŒã‹ã‚‰ã‚€å ´åˆãŒãã‚Œã ã€‚ã—ã‹ã—ã€
perezvon 2009/03/11
security

unicode

charset
ãƒªãƒ³ã‚¯
ç¬¬7å›žâ– æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒç”Ÿã¿å‡ºã™ãœã„å¼±æ€§ã‚’çŸ¥ã‚‹
æ–‡å—ã‚³ãƒ¼ãƒ‰ã«é–¢ã™ã‚‹å•é¡Œã¯å¤§åˆ¥ã™ã‚‹ã¨æ–‡å—é›†åˆã®å•é¡Œã¨æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®å•é¡Œã«åˆ†é¡žã§ãã‚‹ã€‚å‰å›žã¯æ–‡å—é›†åˆã®å–ã‚Šæ‰±ã„ã«èµ·å› ã™ã‚‹ãœã„å¼±æ€§ã«ã¤ã„ã¦èª¬æ˜Žã—ãŸã®ã§ã€ä»Šå›žã¯æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«èµ·å› ã™ã‚‹ãœã„å¼±æ€§ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«ä¾å˜ã™ã‚‹å•é¡Œã‚’ã•ã‚‰ã«åˆ†é¡žã™ã‚‹ã¨2ç¨®é¡žã‚ã‚‹ã€‚ï¼ˆ1ï¼‰æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¨ã—ã¦ä¸æ£ãªãƒ‡ãƒ¼ã‚¿ã‚’ç”¨ã„ã‚‹ã¨æ”»æ’ƒãŒæˆç«‹ã—ã¦ã—ã¾ã†ç‚¹ã¨ï¼Œï¼ˆ2ï¼‰æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®å‡¦ç†ãŒä¸ååˆ†ãªãŸã‚ã«ãœã„å¼±æ€§ãŒç”Ÿã˜ã‚‹ã“ã¨ãŒã‚ã‚‹ç‚¹ã ã€‚ ä¸æ£ãªæ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ï¼ˆ1ï¼‰â€•â€•å†—é•·ãªUTF-8ç¬¦å·åŒ–å•é¡Œ ã¾ãšï¼Œï¼ˆ1ï¼‰ã®ä¸æ£ãªæ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®ä»£è¡¨ã¨ã—ã¦ï¼Œå†—é•·ãªUTF-8ç¬¦å·åŒ–å•é¡Œã‹ã‚‰èª¬æ˜Žã—ã‚ˆã†ã€‚å‰ã€…å›žã«è§£èª¬ã—ãŸUTF-8ã®ãƒ“ãƒƒãƒˆãƒ»ãƒ‘ã‚¿ãƒ¼ãƒ³ï¼ˆè¡¨1ã«å†æŽ²ï¼‰ã‚’è¦‹ã‚‹ã¨ï¼Œã‚³ãƒ¼ãƒ‰ãƒ»ãƒã‚¤ãƒ³ãƒˆã®ç¯„å›²ã”ã¨ã«ãƒ“ãƒƒãƒˆãƒ»ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒå‰²ã‚Šå½“ã¦ã‚‰ã‚Œã¦ã„ã‚‹ãŒï¼Œãƒ“ãƒƒãƒˆãƒ»ãƒ‘ã‚¿ãƒ¼ãƒ³ä¸Šã¯ï¼Œã‚ˆã‚Šå¤šãã®ãƒã‚¤ãƒˆæ•°ã‚’ä½¿ã£ã¦ã‚‚åŒã˜ã‚³ãƒ¼
perezvon 2009/03/03
xss

security

charset
ãƒªãƒ³ã‚¯
ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ç™¾æ™¯
ã“ã‚“ã«ã¡ã¯ã€‚ç™¾åº¦ã¨ã„ã†æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®ä¼šç¤¾ã§ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’æ‹…å½“ã—ã¦ã„ã‚‹æ°´é‡Žè²´æ˜Žã§ã™ã€‚ä¼šç¤¾å‹¤ã‚ã‚’ã—ãªãŒã‚‰ã€æŠ€è¡“ç³»ã®ãƒ©ã‚¤ã‚¿ãƒ¼ã¨ã—ã¦é›‘èªŒã‚„Webã€æ›¸ç±ãªã©ã§æ–‡ç« ã‚’æ›¸ã„ã¦ã‚‚ã„ã¾ã™ã€‚ ä¸€ç·’ã«ä»•äº‹ã‚’ã™ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ã‚¹ã‚¿ãƒƒãƒ•ã«ä¸å›½äººãŒå¤šãã€ã¾ãŸé–‹ç™ºã®å¤šãã‚‚ä¸å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹ã®ã§ã€ä¸å›½èªžã«è§¦ã‚Œãªã‘ã‚Œã°ãªã‚‰ãªã„æ©Ÿä¼šãŒéžå¸¸ã«å¤šããªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ä¸å›½èªžã¨æ—¥æœ¬èªžã‚’ä½µç”¨ã™ã‚‹ãŸã‚ã®åŠªåŠ›ã‚’ç¶šã‘ã¦ã„ã‚‹ç§ã®ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚’ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ â– ä»•äº‹ã¯åŸºæœ¬çš„ã«1å°ã®PC åƒ•ã¯ã€ä»•äº‹ã§ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã‹ã‚‰åŽŸç¨¿åŸ·ç†ã¾ã§ã€åŸºæœ¬çš„ã«1å°ã®PCã§è¡Œã£ã¦ã„ã¾ã™ã€‚åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã¯ã€ThinkPadã®X61ã§ã™ã€‚å®Ÿã¯å…ˆæ—¥ã€ãã‚Œã¾ã§ãšã£ã¨ä½¿ã£ã¦ã„ãŸX32ãŒé…·ä½¿ã«è€ãˆã‹ãã¦ãŠäº¡ããªã‚Šã«ãªã£ã¦ã—ã¾ã£ãŸã®ã§ã€ç¾åœ¨ã®PCã«ä¹—ã‚Šæ›ãˆã¾ã—ãŸã€‚ ã¾ãšã¯ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã§ã™ãŒã€èƒŒæ™¯ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè‰²ã§ã™ã€‚å£ç´™ãªã©ã‚’åˆ©ç”¨ã—ã¦ã„ãªã„ã®ã¯ã€åŽŸç¨¿ã‚’æ›¸
perezvon 2008/09/05
baiduã¯ã‚µãƒ¼ãƒ“ã‚¹ã‚‚ç¤¾å†…ã‚·ã‚¹ãƒ†ãƒ ã‚‚GB18030

ä¸å›½

baidu

charset
ãƒªãƒ³ã‚¯
1