Bad encoding in my database

  • Resolved yard

    (@yard)


    8 years, 1 month ago

    Hi

    I have trouble when opening sql dump. Editor show warning:

    Some characters cannot be converted using the specified encoding.

    View post on imgur.com

    and first occurence is:

    View post on imgur.com

    How can I solve this ?

    Plugin Version : 4.3.1
    WP Version : 4.9.2
    WPMU: No
    MySQL Version : 5.1.73
    PHP Version : 5.5.9

Viewing 2 replies - 1 through 2 (of 2 total)
  • Ambyomoron

    (@josiah-s-carberry)

    8 years, 1 month ago

    So you are saying that you have something in your database in the IP column of that table that is not an IP address? I note that you have ancient versions of MySQL and PHP. I don’t know if that is the problem, but you might consider upgrading them.

    One would expect a value like 0x00000000000000000000ffff3c316acb in that column – all ASCII 7 characters. Perhaps you could use a tool like phpmyadmin to see what is really in the table, to help understand why it appears as a character not available in UTF-8. Then you could work backwards to see how that data ever got in the table in the first place.

    wfalaa

    (@wfalaa)

    8 years, 1 month ago

    Hi @yard
    May I know how exactly you exported this SQL dump? it sounds like something wrong happened while exporting it, it might be related to the encoding settings.

    Also, which version of Wordfence are you using? I couldn’t recognize this version “4.3.1”?

    Thanks.

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

The topic ‘Bad encoding in my database’ is closed to new replies.