{"title":"MySQL Illegal mix of collations \u30a8\u30e9\u30fc\u304c\u51fa\u308b\u30fb\u51fa\u306a\u3044\u307e\u3068\u3081","height":"190","version":"1.0","author_url":"https://blog.hatena.ne.jp/mita2db/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmita2db.hateblo.jp%2Fentry%2F2022%2F01%2F28%2F181313\" title=\"MySQL Illegal mix of collations \u30a8\u30e9\u30fc\u304c\u51fa\u308b\u30fb\u51fa\u306a\u3044\u307e\u3068\u3081 - mita2 database life\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"Illegal mix of collations Illegal mix of collations \u30a8\u30e9\u30fc\u306f \u7570\u306a\u308b\u7167\u5408\u9806\u5e8f\u3067\u7d50\u5408\u3084\u6bd4\u8f03\u3092\u884c\u3063\u305f\u5834\u5408\u306b\u767a\u751f\u3059\u308b\u30a8\u30e9\u30fc\u3067\u3059\u3002 mysql> SELECT CONCAT(_utf8mb4 'A' COLLATE utf8mb4_bin, _utf8mb4 'B' COLLATE utf8mb4_unicode_ci); ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_bin,EXPLICIT) and (utf8mb4_unicode_ci,EXPLICIT) for operatio\u2026","blog_url":"https://mita2db.hateblo.jp/","provider_name":"Hatena Blog","published":"2022-01-28 18:13:13","provider_url":"https://hatena.blog","categories":["MySQL"],"url":"https://mita2db.hateblo.jp/entry/2022/01/28/181313","author_name":"mita2db","blog_title":"mita2 database life","width":"100%","image_url":null,"type":"rich"}