SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Charsets, Collation, Type, etc.

    In my search to find a tool to help manage my DB I've found that none of them use the same settings for Carsets, Collations, Types (and probably other settings). What settings should I use or avoid using? I'm pretty sure I want to use some variant of UTF, since that's what I use for my site, but I don't know which one to pick, and I'm just as confused about types and everything else.

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    what language are you using in your tables? are you concerned with accented characters?

  3. #3
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It'd be rare to see something other than English, but probably not unheard of.

  4. #4
    SitePoint Enthusiast
    Join Date
    Oct 2008
    Posts
    28
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    IMO UTF-8 is what which comes to rescue in most such cases.
    Try this and see if you find any luck.
    Tony Mathew Thomas
    modVPS
    HostingZOOM Inc.
    POWER. SPEED. RELIABILITY.

  5. #5
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, PHPmyAdmin has more than 5 different UTF sets, which is the most "general?"

  6. #6
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    utf-8 that's why it was suggested.


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
  •