Question Marks being added

Viewing 4 replies - 1 through 4 (of 4 total)
  • Michael Milette

    (@mjm4842)

    9 years, 8 months ago

    Did you ever resolved this issue? I am having the same problem except that it not only replaces spaces but also accented characters with question marks.

    Michael Milette

    (@mjm4842)

    9 years, 8 months ago

    If anyone else is having the same problem, I managed to resolve the issue by changing the collation of the database table’s “testimonials” field to “utf8_general_ci”. Unfortunately I still needed to go back and change all of the question marks to their proper character for previously entered content.

    Michael Milette

    (@mjm4842)

    9 years, 8 months ago

    When the plugin first installs, it sets the collation to “big5_chinese_ci”. Changing it to utf8_general_ci or utf_unicode_ci fixes the problem.

    You may want to do all 3 affected fields while you are at it:

    • name
    • testimonial
    • url

    For some reason, only these three get set to big5_chinese_ci. Other text and varchar fields are utf_unicode_ci.

    I haven’t noticed any down side yet to making these changes.

    Michael Milette

    Michael Milette

    (@mjm4842)

    9 years, 8 months ago

    Never mind all that. I just noticed on the “HMS Testimonials Advanced Settings” page, there is an option to set the character set/collation. Look for the following field:

    8. Character Set/Collation
    Note: Changing this will modify your tables.

    You’ll want to change this to utf8_general_ci as mentioned above.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Question Marks being added’ is closed to new replies.