SitePoint Sponsor

User Tag List

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

    Setting DB as UTF-8

    Should my MySQL database be set up as "UTF-8" ??

    Why or why not?


    Debbie

  2. #2
    SitePoint Addict
    Join Date
    Apr 2011
    Posts
    265
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Hi,
    If you want to store in your database texts with less common characters, or specific to other languages, it's better to use UTF-8.
    Free: Web Programming Courses HTML, CSS, Flash
    Web Programming: AJAX Course and PHP-MySQL Course video Lessons
    Good JavaScript and jQuery course for beginners

  3. #3
    SitePoint Wizard DoubleDee's Avatar
    Join Date
    Aug 2010
    Location
    Arizona
    Posts
    3,931
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by MarPlo View Post
    Hi,
    If you want to store in your database texts with less common characters, or specific to other languages, it's better to use UTF-8.
    Doesn't UTF-8 have a lot of "overhead" and like double the size of things?

    Is it worth it?

    I hate to make hasty decisions and regret things later, but I also have to be practical.

    Any suggestions?

    Thanks,


    Debbie

  4. #4
    SitePoint Wizard bronze trophy Immerse's Avatar
    Join Date
    Mar 2006
    Location
    Netherlands
    Posts
    1,661
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)
    Bandwidth and disk space are dirt cheap, so I really really wouldn't worry about the extra bytes used by UTF-8.

    Having said that, if you're not planning (ever) to support foreign characters, then there's no reason not to use latin-1.


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
  •