MYSQL Collations [utf8_general_ci] and [utf8_unicode_ci]. What's the difference?

Question

I'm wondering if there any different between these tow Collations in mysql encoding charset UTF8:
utf8_general_ci and utf8_unicode_ci
They both looks the same! note: For now I'm writing in them in English only, But I'm afraid if it has a side-effect if I inserted in another language like Arabic.

My current conclusion is: using utf8_unicode_ci to ensure wider/better character support. — Omar Al-Ithawi, Oct 04 '09 at 12:56

score 1 · Accepted Answer · answered Aug 25 '09 at 10:53

1

I search on google and I found this link; there is a good explanation.

answered Aug 25 '09 at 10:53

lg.

4,649
3
21
20

MYSQL Collations [utf8_general_ci] and [utf8_unicode_ci]. What's the difference?

1 Answers1