mysqlæ–‡å—コードエラーã®è§£æ¶ˆæ³•æ–¹ - yeyue's diaryMysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=':ã¨ã‹ã„ã†ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦å›°ã£ãŸã€‚ã¾ãšã¯ã€MySQLシステム変数ã®å€¤ã‚’確èªã—ã¾ã—ãŸã€‚ MySQLã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨€èªžãŒ Latin1 ã«è¨å®šã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ã‚³ãƒ³ãƒ‘イルオプションをè¨å®šã—ãªã‹ã£ãŸå ´åˆã¯ Latin1 ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã€my.cnfã®[mysqld]ã«"character-set-server=utf8"ã‚’è¨å®šã—ã€å†èµ·å‹•ã•ã›ãŸã®ã§ä»¥ä¸‹ã®æ§˜ã«è¡¨ç¤ºã•ã‚Œã¾ã—ãŸã€‚ mysql> show variables like '%character%'; +--------------------------+---------------
{{#tags}}- {{label}}
{{/tags}}