As I use Vietnamese for my website, but antispam questions seems not to be unicode. Can you please tell me what table in database contains these antispam questions so that I can fix it or there is any other way to fix it?
They're stored in the params column of the CB AntiSpam plugin row in _comprofiler_plugins. However, you really need to be using language strings to make things easier. For example use CAPTCHA_QUESTION_1=4 then translate it is as follows.
'CAPTCHA_QUESTION_1' => 'What is 2 plus 2?'
Then the storage doesn't matter and you can have multilingual captcha questions (note the question and answer can both be translated and are translated independently). You may also need to supply a new font file to the following location then select it within CB AntiSpam > Parameters > Captcha > Modes > General > Internal using the "Image Font Type" parameter if characters are missing in the captcha image.
You'll really want to use language strings whenever possible instead of storing it as already translated. This avoids storage collation issues. The alternative is to ensure your database tables and columns absolutely have the correct collation (probably utf8_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
