# \#collation

**URL:** https://www.batmunkh.net/tag/collation/92.md

[Latest](https://www.batmunkh.net/latest.md) · [Categories](https://www.batmunkh.net/categories.md) · [Tags](https://www.batmunkh.net/tags.md)

---

## [Change all field collation in MySQL database](https://www.batmunkh.net/t/change-all-field-collation-in-mysql-database/309)

<div class="topic-metadata">

**Author:** [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Replies:** 0\
**Last updated:** [August 4, 2017, 4:08pm UTC](https://www.batmunkh.net/t/change-all-field-collation-in-mysql-database/309 "2017-08-04T16:08:04Z")

</div>

MySQL ашигладаг нэгэн системээ шинэ хувилбар руу шилжүүлсний дараагаар хайлт дээр General error: 1267 Illegal mix of collations (utf8\_bin,NONE) and (binary,COERCIBLE) for operation алдаа гарч ажиллахгүй байв. Тиймээс c…