Ecto (mysql) and UUID

[cboebel]

@isaac-rstor

Can you double check that your character encoding and collation is ok? Ecto’s MySQL doesn’t support certain of MySQL encoding types, and I remember having major problems with uuids that drove me up the wall (but were solvable - except when I had to interface with other databases at work) until I switched to postgres.

Good point, and one that is echoed here: Odd Binary ID Mismatch

I did find that the table was encoded with latin1, so I did this:

ALTER TABLE replication_types CONVERT TO CHARACTER SET utf8;

I tried again. Same results, unfortunately.