{"type":"rich","blog_url":"https://donbulinux.hatenablog.jp/","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdonbulinux.hatenablog.jp%2Fentry%2F2025%2F08%2F26%2F203946\" title=\"Illegal mix of collations - AR \u30db\u30fc\u30e0\u30d9\u30fc\u30ab\u30ea\u30fc\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"Illegal mix of collations","categories":["MySQL"],"version":"1.0","author_name":"donbulinux","blog_title":"AR \u30db\u30fc\u30e0\u30d9\u30fc\u30ab\u30ea\u30fc","author_url":"https://blog.hatena.ne.jp/donbulinux/","height":"190","url":"https://donbulinux.hatenablog.jp/entry/2025/08/26/203946","description":"collation \u304c\u7570\u306a\u308b\u540c\u58eb\u3067\u53c2\u7167\u3057\u3088\u3046\u3068\u3057\u3066\u30aa\u30ef\u3001\u3068\u3044\u3046\u30a8\u30e9\u30fc\u3089\u3057\u3044\u3002 like \u691c\u7d22\u3067\u6b7b\u3093\u3067\u3044\u305f \u89b3\u6e2c\u3057\u305f\u74b0\u5883\u3067\u306f (utf8_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation 'like' \u3068\u3044\u3046\u3053\u3068\u3067\u307e\u3042\u3046\u301c\u3093\u3001\u3068\u3044\u3046\u611f\u3058\u3060\u3063\u305f\u3002 \u96d1\u306b\u6cbb\u3059\u306a\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5168\u4f53\u306b\u7d71\u4e00\u3057\u305f collation \u3067 ALTER \u3057\u3066\u3057\u307e\u3048\u3070\u3044\u3044\u3093\u3060\u3051\u3069\u3001 ALTER \u306f\u3081\u3061\u3083\u30b3\u30b9\u30c8\u9ad8\u3044\u306e\u3067\u3002 \u51fa\u6765\u308c\u3070\u96d1\u3067\u306f\u306a\u304f\u3001\u5b9f\u884c\u3059\u308b\u7bc4\u56f2\u3092\u7d5e\u308a\u305f\u3044\u306a\u3042\u3068\u601d\u3044\u3002 \u300c\u305d\u3046\u3044\u3084 SHOW CREATE TABLE STATUS \u3068\u304b\u3067\u2026","image_url":null,"provider_name":"Hatena Blog","published":"2025-08-26 20:39:46","width":"100%"}