SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. Dec 30, 2008, 16:41 #1
    memco
    memco is offline
    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. Dec 30, 2008, 18:16 #2
    guelphdad
    guelphdad is offline
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    what language are you using in your tables? are you concerned with accented characters?

  3. Dec 30, 2008, 19:08 #3
    memco
    memco is offline
    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. Jan 1, 2009, 01:55 #4
    hztonyt
    hztonyt is offline
    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. Jan 2, 2009, 17:45 #5
    memco
    memco is offline
    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. Jan 2, 2009, 19:09 #6
    guelphdad
    guelphdad is offline
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    utf-8 that's why it was suggested.


« Previous Thread | Next Thread »

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
  •  

Forum Rules