I have Joomla articles on my site written in the Thai language. In the standard Joomla font, they display correctly.
If I post in the Activity feed ( or in groups or profiles ) in the Thai language, I can see the Thai post once, but refreshed, each Thai character is replaced with "?".
I can also dump the posts straight from the database and see they are stored as ?'s.
Guessing some input filter is doing this...
Last edit: 2 years 6 months ago by krileon. Reason: Added [SOLVED] tag to subject
OK, I see this probably has something to do with the database. When I try to update that column directly I get an error:
update ngury_comprofiler_plugin_activity_comments set message = 'ความคิดเห็นอื่น' where id = 25;"
ERROR 1366 (22007) at line 1: Incorrect string value: '\xE0\xB8\x84\xE0\xB8\xA7...'
Clearly though, these characters are somehow escaped or handled correctly in Joomla articles.
Probably database collation error. Correct all your tables and their columns to utf8mb4_unicode_ci collation. You can do this from the Operations tab of phpmyadmin. CB does not touch collations it uses whatever Joomla was set to at time of install otherwise fallsback to your database default collation (which I recommend you also set to utf8mb4_unicode_ci).
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
