Mysql table configuration to insert and select different languages

Question

I am building a web site with a form. This form may be filled in different languages (from English and Spanish to Japanese and Arabic)

I have two questions:

Knowing that, how would you configure the mysql table where the data is going to be stored?

My web is UTF8, is that correct?

use utf8, `utf8_general_ci`. Why? Read this: http://stackoverflow.com/a/367725/889852 P.S.: I suggest you allways use UTF8, and on damand you can optimize for specific language. — Ernestas Stankevičius, Mar 02 '16 at 08:56

score 0 · Accepted Answer · answered Mar 04 '16 at 23:28

0

If you will be accepting Chinese, too, then go all the way -- use utf8mb4. That is a superset of utf8; to handle a few more Chinese characters.

For collation, utf8mb4_unicode_520_ci is probably the best overall.

answered Mar 04 '16 at 23:28

Rick James

1 Answers1