By Guest on Friday, 29 May 2015
Replies 5
Likes 0
Views 3.7K
Votes 0
When I try to save the Chinese characters in the event title and description, the characters each turn into "?". FYI, there are no problems saving Chinese characters in other parts of this Joomla instance (articles, modules, menus).


PHP Version : 5.3.25
MySQL Version : 5.5.37-cll
Joomla : 3.4.1
component_com_jevents : 3.2.5
module_mod_jevents_cal : 3.2.5
module_mod_jevents_custom : 3.2.5
module_mod_jevents_filter : 3.2.5
module_mod_jevents_latest : 3.2.5
module_mod_jevents_legend : 3.2.5
module_mod_jevents_switchview : 3.2.5
plugin_content_jevents : 3.2.5
plugin_finder_jevents : 3.2.5 (not enabled)
plugin_search_eventsearch : 3.2.5
Please check your database table collation using PHPMyAdmin
·
Sunday, 31 May 2015 13:00
·
0 Likes
·
0 Votes
·
0 Comments
·
The collation is utf8_general_ci, which is the same as all my other Joomla instances (and those were able to save Chinese characters in JEvents).
·
Saturday, 06 June 2015 00:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Actually, after a more careful inspection, I just found out that only the JEvents database tables had the collation of latin1_swedish_ci. I went ahead and changed it, but even so, the problem still persists with characters getting turned into "?". Are there other changes that should be made in the Jevent files with regards to collation?
·
Saturday, 06 June 2015 00:33
·
0 Likes
·
0 Votes
·
0 Comments
·
did you check the column collation (as well as the table collation).
·
Sunday, 07 June 2015 09:53
·
0 Likes
·
0 Votes
·
0 Comments
·
Bingo!!! That did the trick! Thank you so much, Geraint, for your time and great help!!!
·
Tuesday, 09 June 2015 21:19
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post