ASTRAPI Posted June 9, 2014 Share Posted June 9, 2014 Hi What is better to use for the database collation? Utf8-general_ci or Utf8-unicode_ci Thank you Link to comment Share on other sites More sharing options...
Management Matt Posted June 9, 2014 Management Share Posted June 9, 2014 utf8_unicode_ci Link to comment Share on other sites More sharing options...
ASTRAPI Posted June 9, 2014 Author Share Posted June 9, 2014 Is it faster? Is it more compatible? Some more info? Link to comment Share on other sites More sharing options...
Aiwa Posted June 9, 2014 Share Posted June 9, 2014 general is faster, but comparisons are less accurate. Unicode is more accurate. In the age of computing we live in, the speed difference you get with general is negligible. Your MUCH better off using Unicode for accuracy of comparisons. You'll find similar discussions with a quick google search. Link to comment Share on other sites More sharing options...
Grumpy Posted June 9, 2014 Share Posted June 9, 2014 Full read: http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-sets.html (starts talking about it after the big list at the top) And actual difference explanation post: http://forums.mysql.com/read.php?103,187048,188748 Personally prefer general for speed. It's up to you, really. xxx_general_ci is default choice of mysql. Link to comment Share on other sites More sharing options...
Management Matt Posted June 9, 2014 Management Share Posted June 9, 2014 We use utf8_unicode_ci in IPS 4, and we check to make sure its being used. Link to comment Share on other sites More sharing options...
marklcfc Posted June 9, 2014 Share Posted June 9, 2014 Any news on the converter Link to comment Share on other sites More sharing options...
ASTRAPI Posted June 9, 2014 Author Share Posted June 9, 2014 Thanks all of you :) Link to comment Share on other sites More sharing options...
stoo2000 Posted June 9, 2014 Share Posted June 9, 2014 Any news on the converter It's routinely >being updated to fix reported bugs and add new features. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.