Inconsistent database to schema - Issue with advagg_install_change_table_collation()

That doesn't match what is in the code http://cgit.drupalcode.org/advagg/tree/advagg.install#n131

There is no TODO anywhere. Help me understand what's wrong. What did you use to get your information and what type of SQL server do you have.

      'content_hash' => array(
        'description' => 'Hash of the file content. Used to see if the file has changed.',
        'type' => 'char',
        'length' => 43,
        'not null' => TRUE,
        'default' => '',
        'binary' => TRUE,
        'collation' => 'ascii_bin',
        'charset' => 'ascii',
      ),

https://www.drupal.org/project/schema is the module in question; I'll take a look at it tomorrow

Missing descriptions has to do with the way the schema module is used.

Inside the schema_compare function it calls drupal_get_schema this then calls drupal_get_complete_schema which then calls _drupal_schema_initialize which removes the description from every entry.

In order for the schema module to actually work correctly it would need to implement it's own version of drupal_get_complete_schema() that calls _drupal_schema_initialize($schema, $module, $remove_descriptions) where $remove_descriptions is set to FALSE. This is a bug in the schema module.

Root of this issue is the advagg_install_change_table_collation function.