1

Possible Duplicate:
UTF-8: General? Bin? Unicode?

I'm running some tests on finding the right collation for the right table. Is it correct to assume that if a table were to contain user submitted data (profiles info, etc.) or authentication data (hashes, etc.) a collation of utf8_bin would work well while all the rest can be in utf8_general_ci which is faster?

Or should everything just be the same collation?

Community
  • 1
  • 1
enchance
  • 29,075
  • 35
  • 87
  • 127
  • 2
    [UTF-8: General? Bin? Unicode?](http://stackoverflow.com/questions/2344118/utf-8-general-bin-unicode) – mishmash Jan 12 '13 at 14:47
  • 4
    Why would case and diacritic insensitive comparisons be more performant than direct binary comparisons – Esailija Jan 12 '13 at 14:49

0 Answers0