Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
ASTRAPI Posted June 9, 2014 Posted June 9, 2014 Hi What is better to use for the database collation? Utf8-general_ci or Utf8-unicode_ci Thank you
ASTRAPI Posted June 9, 2014 Author Posted June 9, 2014 Is it faster? Is it more compatible? Some more info?
Aiwa Posted June 9, 2014 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.
Grumpy Posted June 9, 2014 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.
Management Matt Posted June 9, 2014 Management Posted June 9, 2014 We use utf8_unicode_ci in IPS 4, and we check to make sure its being used.
stoo2000 Posted June 9, 2014 Posted June 9, 2014 Any news on the converter It's routinely >being updated to fix reported bugs and add new features.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.