Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: Joebloggs on October 04, 2015, 09:59:04 PM

Title: table collation
Post by: Joebloggs on October 04, 2015, 09:59:04 PM
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?
Title: Re: table collation
Post by: alec on October 05, 2015, 02:34:32 AM
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?
Title: Re: table collation
Post by: Joebloggs on October 05, 2015, 01:13:18 PM
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.