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

  • 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.

    - 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.


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks