Results 1 to 2 of 2

Thread: MySQL Collation

  1. #1
    Join Date
    Oct 2010
    Location
    My world u just live here
    Posts
    1,410

    Question MySQL Collation

    I've never really bothered much when it came to the 'collation' setting in MySQL. But I noticed I had a lot of mixed values. Including some old latin value. I've read up a little and I've come down to these 4

    utf8_unicode_ci
    utf8_unicode_520_ci
    utf8mb4_unicode_ci
    utf8mb4 unicode 520_ci

    From my understanding uft8mb4 would be good for character with mutli language (character) support (japanese for example). uf8 only supports 3 bytes while uf8mb4 supports 4 bytes. So it sound like the obvious choice would be uf8mb4, but the catch seems to be that you have a length limit (Damn it! I want my cake and eat it too), which is a little concern (I think).

    Then you take into account about the 520 standard; which offers more, from what little I could find on it. But that is of course the issue, I could find very little about it. Only that people say it's an improvement, yet being very vague on how that is.

    So being that I do want to learn and I do want the most I can get with as few restrictions as possible... I figured someone here may know a thing or two.

    ▲ ▲

    WoltLab Dev

  2. #2
    Join Date
    Oct 2010
    Location
    My world u just live here
    Posts
    1,410
    I seemed to have posted this twice here on WHT. Likely because I posted this elsewhere and got confused as to where I had posted.

    So as to connect the two, here was my resolve
    http://www.webhostingtalk.com/showthread.php?t=1378660

    Admittedly though... I never did exactly get the answers I was looking for (having posted this one several site). Yet for what little I could come up with this seems to be what I've settled on.

    ▲ ▲

    WoltLab Dev

Similar Threads

  1. mysql collation question ?
    By LiveAndGo in forum Hosting Security and Technology
    Replies: 3
    Last Post: 06-21-2007, 02:26 PM
  2. MySQL Collation?
    By ChrisF79 in forum Programming Discussion
    Replies: 5
    Last Post: 11-09-2006, 02:53 PM
  3. Mysql Collation
    By creativepart in forum Dedicated Server
    Replies: 0
    Last Post: 06-20-2006, 11:56 AM
  4. Mysql collation issue?
    By ayksolutions in forum Hosting Security and Technology
    Replies: 13
    Last Post: 03-24-2006, 12:01 PM
  5. Mysql 4.1 Collation
    By Serverplan in forum Hosting Security and Technology
    Replies: 5
    Last Post: 05-03-2005, 06:11 PM

Posting Permissions

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