I had a table with no collate options set. I used Adminer to set 'collate nocase' for several text fields. It looks like that has effect.
- Dump does confirm that it was set.
- ShowStructure does not show the collation value.
- AlterTable does not show the collation value. It pretends no collation value is set.
Is all that on a todo list somewhere?
Adminer doesn't show collation in Show Structure.
I'll fix it in Alter Table.
Fixed in Git.
So when will it be available in a release? I (better: Adminer!) broke another database because I changed a column in a table and the collation was lost when it was saved. That's a really bad thing!
Feel free to use the development version before the next version is released. It's pretty stable, I use it too.