How can I tell what collate options have been set for a table?

HarryD
2013-08-27
2013-12-14
  • HarryD
    HarryD
    2013-08-27

    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.

    However:
    - 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?

     
    Last edit: HarryD 2013-08-27
  • Jakub Vrána
    Jakub Vrána
    2013-08-28

    Adminer doesn't show collation in Show Structure.
    I'll fix it in Alter Table.

     
  • Jakub Vrána
    Jakub Vrána
    2013-08-28

    Fixed in Git.

     
  • HarryD
    HarryD
    2013-11-27

    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!

     
  • Jakub Vrána
    Jakub Vrána
    2013-12-14

    Feel free to use the development version before the next version is released. It's pretty stable, I use it too.