database charset error (3 posts)

  1. toniov
    Posted 3 years ago #

    Hi and thank you again for the great plugin. Nice update as well.
    In this new update, I am now though unable to batch import questions in the php database because of a charset error. (you can see black diamonds interrogation marks when clicking modify in wp_wp_pro_quiz_question array in php-myadmin.) I think this error is related to a different charset being presented: see http://stackoverflow.com/questions/275411/php-output-showing-little-black-diamonds-with-a-question-mark
    I would like to import 200 question and cant do it manually. I did it flawlessly on a previous version.
    Can you help?


  2. toniov
    Posted 3 years ago #

    The black diamonds interrogation marks (replacement character)occurs before every * and _ in your answer_data column from wp_wp_pro_quiz_question array in mysql as follow: �*�_
    Also the fact that it is now necessary to specify string length is making the problem even more complicated because string length is different in the different types of charset.
    Thanx in advance.

  3. toniov
    Posted 3 years ago #


    1. added in place of the replacement character giving *_

    2. made a formula in excel to count string length and differentiate special characters (æ, å, ø...)

    3. "sanitized" my data before exporting it by opening and saving my excel-created CSV in Notepad++ (it was not sufficient to save it in UTF-8 from excel.)

    4. Almost turned mad after two day trying to find this workaround. I'm quite convinced though, that there must be a simpler way....

    Again great plugin! I suggest you implement a way to upload "human readable and modifiable" files in addition to the .wpq files.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Wp-Pro-Quiz
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic