Skip to Content Skip to Menu

Database Collation Issue

8 years 8 months ago - 8 years 8 months ago #279642 by tjohns92109
Database Collation Issue was created by tjohns92109
I'm surprised I didn't notice this before, but all the tables in all the websites I've created are utf8_general_ci collation. Except every community builder (comprofiler) associated table is latin1_swedish_ci collation.

I know the CB team is aware of this because I've seen posts as old as 9 years regarding this. But I couldn't really find anything that says it's an issue. I did find other posts on other websites saying that you shouldn't mix collations and that it should be fixed.

Is this an issue? Does it need to be fixed? And, if it is an issue, what is causing it?

1. You provide exact Joomla version
Any/Every

2. You provide exact Community Builder version and make sure that it is the latest
Any/Every

3. You provide exact PHP version and MYSQL version
Any/Every

4. You provide exact steps so we can replicate the exact issue you are seeing on our clean install
Go into PHPMyAdmin & look at comprofiler tables

5. You give exact details of complete error message or behavior you are seeing
Done.
Attachments:
Last edit: 8 years 8 months ago by tjohns92109. Reason: Forgot to include the '5 rules'.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum