1. Forums
  3. Community Discussions
  5. Community Builder
  7. Usage
  9. filtering of characters in Editor Text Area field

filtering of characters in Editor Text Area field

8 years 11 months ago #264586 by michwebdev
filtering of characters in Editor Text Area field was created by michwebdev
Upon saving, characters in fields (type "Editor Text Area") are converted to "?". For example, the word "Politička" becomes "Politi?ka".

When I try the same thing in a Joomla article, this does not happen so I am suspecting there is some filtering going on in Community Builder. The database entry in the j25_comprofiler table shows "Politi?ka" as well so I suspect this is not just a display issue. Is there a setting somewhere to adjust filtering?

Community Builder: 2.0.8
Joomla 3.3.6
JCE Editor: 2.4.6

Please Log in to join the conversation.

8 years 11 months ago #264614 by nant
Replied by nant on topic filtering of characters in Editor Text Area field

michwebdev wrote: Upon saving, characters in fields (type "Editor Text Area") are converted to "?". For example, the word "Politička" becomes "Politi?ka".

When I try the same thing in a Joomla article, this does not happen so I am suspecting there is some filtering going on in Community Builder. The database entry in the j25_comprofiler table shows "Politi?ka" as well so I suspect this is not just a display issue. Is there a setting somewhere to adjust filtering?

Community Builder: 2.0.8
Joomla 3.3.6
JCE Editor: 2.4.6


Most likely your CB related Joomla database tables are not set to the proper collation.

Everything (for multilanguage / non English) sites should be set to utf8_general_ci.

Search google for more help.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

Please Log in to join the conversation.

8 years 10 months ago #265016 by michwebdev
Replied by michwebdev on topic filtering of characters in Editor Text Area field
After making the change below to the column where the characters were needed (in the comprofiler table), the issue was resolved:

ALTER TABLE dbprefix_comprofiler MODIFY columnname mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci;

Thanks for the tip!

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Community Discussions
  5. Community Builder
  7. Usage
  9. filtering of characters in Editor Text Area field
Time to create page: 0.276 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Community Discussions
  4. Community Builder
  5. Usage
  6. filtering of characters in Editor Text Area field

Search

Login / Logout

User Menu