Antispam Question Not Unicode

Dear supporters,

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?

Thank you and regards,

Hai Dinh

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.

components/com_comprofiler/plugin/user/plug_cbantispam/fonts/

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).