In my mysql set up, tables and their columns are automatically given utf8_unicode_ci collation. However, there is one table where I want no collation.

How do you set that up? Also, is it possible to remove collation from a table?

Cheers

解決方案

You can change the collation of a column using alter table, for example assuming your column is a VARCHAR(40):

alter table YourTable modify YourColumn varchar(40) collate utf8_bin;

If you don't want any collation at all change the column type to binary, varbinary or blob:

alter table YourTable modify YourColumn varbinary(40);

You can also change the default collation of a table but it only affects columns you create afterwards.

總結

以上是生活随笔為你收集整理的mysql 排序 删除_是否可以删除mysql表排序规则？的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。