Results 1 to 2 of 2
Thread: MySQL Collation
-
05-24-2014, 11:46 AM #1Web Hosting Master
- Join Date
- Oct 2010
- Location
- My world u just live here
- Posts
- 1,410
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.
-
05-25-2014, 03:29 PM #2Web Hosting Master
- 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.
Similar Threads
-
mysql collation question ?
By LiveAndGo in forum Hosting Security and TechnologyReplies: 3Last Post: 06-21-2007, 02:26 PM -
MySQL Collation?
By ChrisF79 in forum Programming DiscussionReplies: 5Last Post: 11-09-2006, 02:53 PM -
Mysql Collation
By creativepart in forum Dedicated ServerReplies: 0Last Post: 06-20-2006, 11:56 AM -
Mysql collation issue?
By ayksolutions in forum Hosting Security and TechnologyReplies: 13Last Post: 03-24-2006, 12:01 PM -
Mysql 4.1 Collation
By Serverplan in forum Hosting Security and TechnologyReplies: 5Last Post: 05-03-2005, 06:11 PM