Copying wordpress content into other MySQL databases messes up characters

Discussion in 'MySQL' started by Glowing Face Man, Mar 29, 2010.

  1. #1
    Hello,

    I have a database I made myself (a webcomic database). If I copy some content from wordpress and paste it into this new database, into a TEXT field to be specific, and then I load that text up and slap it on a webpage using a php script, then wordpress's nonstandard characters (such as ’) show up as gibberish.

    I tried changing the collation from "latin1_swedish_ci" (the default in phpmyadmin) to "utf8_general_ci" (to match the collation in the wordpress database) but that doesn't seem to fix the problem.

    I'd be very grateful if anyone can explain how to fix this :)

    -Sam
     
    Glowing Face Man, Mar 29, 2010 IP