Importing in mysql - characters disappearing

Discussion in 'MySQL' started by login, Jun 2, 2007.

  1. #1
    Hi. I am importing databases, but when the text is important it misses special scandinavian characters. How can I import the db a keep the characters ?
     
    login, Jun 2, 2007 IP
  2. miware

    miware Peon

    Messages:
    10
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It sounds like a character set issue. Are you using MySQL 4.1+? Have the character sets for the database/tables set when creating the tables?

    I know for some Danish characters you cannot use utf8 as the character set in MySQL. If you use latin1 then the characters will store just fine.
     
    miware, Jun 2, 2007 IP
    login likes this.
  3. login

    login Notable Member

    Messages:
    8,849
    Likes Received:
    349
    Best Answers:
    0
    Trophy Points:
    280
    #3
    Thanks miware. I just solved the problem. It was when I was importing. I had to import the db as latin1. It was set utf-8 as default.
     
    login, Jun 2, 2007 IP