Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 9, 201410 yr Hi What is better to use for the database collation? Utf8-general_ci or Utf8-unicode_ci Thank you
June 9, 201410 yr 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.
June 9, 201410 yr 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.
June 9, 201410 yr Management We use utf8_unicode_ci in IPS 4, and we check to make sure its being used.
June 9, 201410 yr Any news on the converter It's routinely >being updated to fix reported bugs and add new features.
Archived
This topic is now archived and is closed to further replies.