CODEWITHSUNDEEP
mysqldatabaseschema
Mady Cool
Mady Cool

Reputation: 109

Multilingual Datatype in MYSQL

Can anyone tell me which data type i have to use to make my field multilingual ?

I have to give facility to user that they can use username in multiple language. Like,

Chinese, French, English, Hindi, Gujarati, Japanese etc.

I have to store user name in MYSQL database.

Upvotes: 3

Views: 3785

Answers (1)

xray1986
xray1986

Reputation: 1168

Change your collation to uft8_unicode_ci so you can account for Multilanguage characters. There are other questions on the same subject i believe.

Here is a link to show you how to do it: http://docs.moodle.org/23/en/Converting_your_MySQL_database_to_UTF8

Upvotes: 4

Related Questions