SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard DoubleDee's Avatar
    Join Date
    Aug 2010
    Location
    Arizona
    Posts
    3,915
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Database Collation...

    What MySQL Database Collation should I choose, and why?

    Sincerely,


    Debbie

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,322
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by DoubleDee View Post
    What MySQL Database Collation should I choose, and why?
    hey debbie, have a look at these resources and tell us which collation you're thinking of using

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Wizard DoubleDee's Avatar
    Join Date
    Aug 2010
    Location
    Arizona
    Posts
    3,915
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    hey debbie, have a look at these resources and tell us which collation you're thinking of using

    The more I read, the more confused I become...

    It seems like these days everyone says, "Use UTF-8", but I don't even know what that means?!

    When I click on my database in phpMyAdmin, I see Collation = latin1_swedish_ci


    All of this came up today because I had to re-create two tables, and during that process I saw a field for colation

    I sense this is a *MAJOR* topic in and of itself...


    What I do know is this...

    1.) I am in the U.S.
    2.) My website only supports English
    3.) All of my Regular Expressions in PHP have very limited character sets (e.g. [a-z0-9_.-] )


    At the same time, I don't want to be overly restrictive to International Visitors when it comes to things like...

    - Posting Comments
    - Sending PM's


    Not sure what to do, but I figured NOW is a better time to ask, versus after I have 10,000 users on my website!!!

    Sincerely,


    Debbie


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
  •