Latin1 to UTF8

Discussion in 'MySQL' started by tiksa, Apr 25, 2012.

0
  1. #1
    How cani convert mysql database form Swedish latin1 to UTF8.?
     
    tiksa, Apr 25, 2012 IP
  2. Iann@LFCVPS

    Iann@LFCVPS Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you want to convert a single table, use this:

    If the database is empty, this should work:

    If you have a lot of tables, I'm not sure there's an easier way other than mysqldumping the database and then editing the resulting sql file and changing the CREATE TABLE statements to the proper charset and then importing the database back in.
     
    Iann@LFCVPS, Apr 27, 2012 IP