#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    10

    Which collation is ideal for a multiple-language-supporting database?


    1) Which Collation should I select for a web site database which can receive all languages and characters?

    2) Using phpmyadmin, my General Settings indicate utf8_general_ci. So why, when I create tables, are they latin1 by default?

    Thanks.
    Thanks,
    Dan

    Operating system ubuntu 12.04
  2. #2
  3. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,921
    Rep Power
    1045
    Hi,

    I guess you mean the character set and encoding. The collation only defines the order of characters.

    Whenever you have to deal with non-ASCII characters, you should use the Unicode character set, encoded with UTF-8.

    I have no idea why phpmyadmin suggests Latin-1. This character set is obsolete and shouldn't be used.
    The 6 worst sins of security ē How to (properly) access a MySQL database with PHP

    Why canít I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".
  4. #3
  5. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,301
    Rep Power
    7170
    The collation value that you select under "General Settings" only applies to the database connection that phpMyAdmin uses to connect to the server; it doesn't have anything to do with the default values for creating databases/tables/fields.

    When you go to create a database, table or field, phpMyAdmin uses whatever character set is set as the default at the server, database or table level. latin1 is the default default in MySQL 5, you can change the default at the server level by modifying the configuration file. You can also set a different default at the database or table levels.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around

IMN logo majestic logo threadwatch logo seochat tools logo