jeremyevans/sequel — Issue #445: Can't get column collate option to work with MySQL
Author: myronmarston
Created: 2012-02-25 00:06:28+00:00
State: open

It appears that sequel supports a column collate option:

https://github.com/jeremyevans/sequel/blob/a7e05a408e0b99a08c3161e46d1d61bea30333ce/spec/core/schema_spec.rb#L266-270

However, when I try the same syntax in my migration using MySQL and the MySQL2 gem:

``` ruby
require 'sequel'

Sequel.migration do
change do
create_table(:cats) do
varchar :name, :collate => :utf8_bin
end
end
end
```

...then the collate option is ignored. Here's the table definition that MySQL tells me was run:

```
CREATE TABLE `cats` (
`name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
```