Roundcube Community Forum

 

table collation

Started by Joebloggs, October 04, 2015, 09:59:04 PM

Previous topic - Next topic

Joebloggs

Version 1.1.3

After completing the installer I connected to the mysql database with heidisql and found that all tables were CHARACTER SET utf8 COLLATE utf8_general_ci except contactgroupmembers which was CHARACTER SET latin1 COLLATE latin1_swedish_ci

Why does contactgroupmembers use a different collation?

alec

Indeed, that what would happen when your database default is latin1_swedish_ci. That shouldn't be a problem as this table does not contain any text columns. Or do you see some errors related with that?

Joebloggs

I'm not seeing any error, I just wondered why it was different.
Since my default collation could have been different I decided to change that table to utf8_general_ci
I guess this won't cause any issues but I'll find out if it does. I haven't used the address book yet.