SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict
    Join Date
    Jun 2008
    Posts
    218
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database Character Set and Collation settings

    I'm relatively new to creating mysql databases and have just started to build a new one for a small job i have.

    I've wondered this a couple of times before but just continued as everything was working ok!!

    What should i set the Character set / Collation values to? I'm based in the Uk and the database will be used by a UK small business if its relevant.

    Previously i have just used the default but when i go check the properties of the database it shows them as latin1 for Character set and latin1_swedish_ci for the collation??

    Is this Ok or should i be using another value given that i'm UK based and will be putting in english characters / numerics?

    Thanks

    James

  2. #2
    SitePoint Evangelist
    Join Date
    Aug 2007
    Posts
    566
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For only English characters, there should be no problems.
    It's rather for us French speaking peoples, and nordic too, an unicode_general_ci collation would be better, as it would allow characters like é, è, à, ø and such.

  3. #3
    SitePoint Addict
    Join Date
    Jun 2008
    Posts
    218
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK thanks for the reply, it gives me some piece of mind!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •