Joomla Extensions Club 20,483 posts

[baijianpeng Friend baijianpengJoin date: March 2006Posts: 96Downloads:281Uploads:5 Thanks: 6 Thanked: 1 times in 1 posts]

#962552

I made a testing website with JA University template the latest version. I use the JA Side News Module in this template to show a news module at "sidebar-2" position. You can see it at:

http://joomla.cn.tn/

The module title is "微想精彩".

You can see that when truncating the description text, there is two un-readable strnage symbols (like ? but not really a question mark) at the point of cutting off text.

Why this happened?

It seems that this module can not handle Chinese characers properly.

Could you please improve it to support Chinese language ?

Thank you.

---

Attachments:

1. 

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#962973

@baijianpeng

What is the database collation of your site? For languages with special characters like yours, the database collation should be utf8

[baijianpeng Friend baijianpengJoin date: March 2006Posts: 96Downloads:281Uploads:5 Thanks: 6 Thanked: 1 times in 1 posts]

#963417

Following is the "system infomation" from my Joomla backend:

Database Version 5.6.31-77.0
Database Collation latin1_swedish_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.0.8
Web Server Apache
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.6.2 Stable [ Noether ] 4-August-2016 23:41 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Did you used mb_substr() instead of substr() for that truncating feature?

Thank you.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#963824

Did you get it solved? I see the title is fine now.

[baijianpeng Friend baijianpengJoin date: March 2006Posts: 96Downloads:281Uploads:5 Thanks: 6 Thanked: 1 times in 1 posts]

#964246

Yes, I did a replacement: replace ALL "substr" with "mb_substr" in all files (not only php files, but all files) of that module, now it can truncate Chinese characters properly.

I hope you improve your module with this same method. Otherwise, next time I upgrade this module the problem will come back again.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#964437

I lined it up in our bug tracking system and it will be updated in upcoming version: http://pm.joomlart.com/browse/JAECMODSIDENEWSJIVI-87

Thank you for your report! It’s much appreciated.

[Author]

Posts