Multilanguage MySQL problem

Discussion in 'MySQL' started by Cooker, Jun 23, 2009.

0
  1. #1
    Hi,
    I have to create a database, with text with three different languages... what should i do to make the text ok in all of them,

    Thanks,

    Cooker
     
    Cooker, Jun 23, 2009 IP
  2. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #2
    Create a UTF8 Database. What languages do you will use ? The utf8 unicode collation is different between languages ...
     
    sacx13, Jun 23, 2009 IP
  3. Cooker

    Cooker Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    english, polish russian
     
    Cooker, Jun 23, 2009 IP
  4. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #4
    Try:

    CREATE DATABASE db DEFAULT CHARACTER SET utf8;

    CREATE TABLE table (name VARCHAR(255) , id INT) DEFAULT CHARACTER SET utf8;

    Store in name both Polish and Russian chars (for english will not be a problem) and test to see if is all ok. Be aware, your Webserver should also know UTF8 .

    Regards
     
    sacx13, Jun 23, 2009 IP
  5. Cooker

    Cooker Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Ok, Thank You
     
    Cooker, Jun 23, 2009 IP