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.
Reported to Joomlapolis. Awaiting response...
Dev & Tech Notes
San Diego | Los Angeles | Big Bear | USA
Terms & Conditions ©2005-2024 TJohns.co
Terms & Conditions ©2005-2024 TJohns.co
Articles in this Category
- Can't Logout of Community Builder
- Community Builder - Specific Fields Display for Groups
- Community Builder Collation Issue
- Community Builder Content Substitutions
- Community Builder Custom Template Overrides
- Community Builder Issue with CB Activity Replies
- Community Builder Profile Links
- Community Builder Registration Issue with Icons/Descriptions
- Customize Community Builder Language
- Getting IDs for Community Builder User Viewing & User Displayed
- Imperfections with CB Gallery Plugin
- Issue with Community Builder Integer Field
Top Left Text cha
Web & App Development
Community Builder Collation Issue
- Details
- Written by Timothy Johns
- Category: Community Builder
- Hits: 2282
Comments