The 3 address book tables were created as MyISAM type and with latin1_swedish_ci collation. My database default is InnoDB and UTF8_general_ci.

I have not been able to determine yet if this is causing any problems, but I wanted to post this as a data point.

Thanks!

Comments

wplaat’s picture

wplaat commented
Assigned: Unassigned » wplaat

Ho Verta,

If this is a problem please let me known. On this moment i will not execute any actions.

Willem

verta’s picture

verta commented

I don't know if it's going to be a problem or not, I have not been using MySQL or Drupal long enough, but I have thought that creating new tables should respect the collation sequence and language settings of the base database? It's a concern as it seems that this might influence primary keys and indices.

It's flagged as causing a critical error in the main codebase for version 7, with some detailed material from user sun here #772678: Database default collation is not respected.