mysqlã®collateを使ã£ã¦å¤§æ–‡å—-å°æ–‡å—や全角-åŠè§’を無視ã—ãŸæ¤œç´¢ - end0tknr's kipple - web写経開発mysqlã§ã¯ã€collate = utf8_unicode_ciを指定ã™ã‚‹ã¨ã€å¤§æ–‡å—-å°æ–‡å—ã ã‘ã§ãªãã€å…¨è§’-åŠè§’ã‚’åŒä¸€è¦–ã§ãã‚‹ãã†ã§ã™ãŒã€å®Ÿéš›ã«ã©ã®æ–‡å—ãŒåŒä¸€è¦–ã•ã‚Œã‚‹ã®ã‹ã‚’試ã—ã¦ã¿ã¾ã—ãŸã€‚ collateã¨ã¯ http://tetlist.info/2009/01/mysql ↑ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã‚‚分ã‹ã‚Šã‚„ã™ã紹介ã•ã‚Œã¦ã„ã¾ã™ãŒã€collate(ç…§åˆé †åº)ã¨ã¯ã€æ–‡å—を比較(一致/ä¸ä¸€è‡´ã‚„è¡¨ç¤ºé †)ã™ã‚‹éš›ã®ãƒ«ãƒ¼ãƒ«ã§ã™ã€‚ utf8_unicode_ciã§å¤§æ–‡å—-å°æ–‡å—ã ã‘ã§ãªãã€å…¨è§’-åŠè§’ã‚’åŒä¸€è¦– mysqlã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆcollateã§ã‚ã‚‹utf8_general_ciã§ã¯ã€å¤§æ–‡å—-å°æ–‡å—ã‚’åŒä¸€è¦–ã—ã¾ã™ãŒã€utf8_unicode_ciã§ã¯ã€ã•ã‚‰ã«åŠè§’-全角もåŒä¸€è¦–ã—ã¾ã™ã€‚ ※ci ã¨ã¯ Case Insensitive ã®ç•¥ç§°ã®ã‚ˆã†ã§ã™ tableã‚„column自体ã«collateã‚’è¨å®šã™ã‚‹
[MySQL]カラムã®COLLATE/CHARACTER SETã‚’å†è¨å®šã™ã‚‹ | ã†ãˆã¡ã‚‡ã“ï¼ ã¼ã‚ã![[MySQL]カラムã®COLLATE/CHARACTER SETã‚’å†è¨å®šã™ã‚‹ | ã†ãˆã¡ã‚‡ã“ï¼ ã¼ã‚ã](https://cdn-ak-scissors.b.st-hatena.com/image/square/8d71ff5111e05619a10d29bb40d7aebaa75c8fbc/height=288;version=1;width=512/https%3A%2F%2Fs0.wp.com%2Fi%2Fblank.jpg)
SQLServer ã® collation (ç…§åˆé †åº)ã®è¨å®š - Enjoi Blog
{{#tags}}- {{label}}
{{/tags}}