WordPress.org

Ready to get started?Download WordPress

Forums

UTF8 Problems? (5 posts)

  1. jamespoling
    Member
    Posted 7 years ago #

    I'm moving to a new host and trying to move my database using phpMyAdmin to export from the old DB and import to tne new DB.

    I'm having trouble with some quirky characters showing up. It seems it's mostly happening on certain quotation marks.

    “The sad part about Elisabeth is that she is the dumbest person on television,� Trump told “Inside Edition.� “I mean she’s supporting the war in Iraq, which is pretty hard to do.�

    “Don’t block the box” signs have been around NYC for a while but they seem to be about as effective as the no honking signs that are plastered everywhere.Â

    Suing YouTube is the new black.  The NJTA is suing YouTube for the removal of a video that shows a pretty horrific single car accident that was caught on tape an NJTA camera.Â

    I've done some searches here and it seems like some people have had the same issue but when upgrading. I'm moving from 2.2 to 2.2.

    I also can't seem to find one total solution to stop this from happening. I'm wondering if SSH'ing the DB over would perhaps fix this, although I have no idea how to SSH so I'm not sure I could even do it.

    Is there one surefire fix for this issue?

  2. lelion
    Member
    Posted 7 years ago #

    Search the forums here... You'll find a lot of threads which might help you:)

    Basically, it could be related to SET NAMES and COLLATION in the MySQL... Search well!

    Someone more experienced than me can help you more on that...

  3. jamespoling
    Member
    Posted 7 years ago #

    does anyone know if SSH'ing the DB instead of using phpMyAdmin will result in the same issues?

  4. lelion
    Member
    Posted 7 years ago #

    I dunno...

    Maybe different hosts run different versions of MySQL. Or maybe it's related to the default connection to the database... I am not very good at that, sorry :-/

    SET NAMES, COLLATION can help, dig deeper...

    Would be nice if someone with a lot of experience of MySQL and how PHP scripts interact with it (concerning the encoding issue) would post something here.. :)

  5. BigBri
    Member
    Posted 7 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic