UTF8 Problems?

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

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

    “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?

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

  • 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…

    Thread Starter jamespoling

    (@jamespoling)

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

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

    My Solution

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘UTF8 Problems?’ is closed to new replies.