How to store string containing different language (like Chinese, hindi etc) in MySql 5.0

Question

I am making use of mysql 5.0. Is there a way to store a string containing different language other than english? I tried to store the language Kannada but its storing it as "?????". i even tried changing encoding to utf-8, dosent work. (sqlyog)

Answer 1

change the field collation to :-

utf8_general_ci

Answer 2

You should execute this command..

ALTER TABLE CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Answer 3

Simply use the following query to change the column as utf8:

  ALTER TABLE TableName MODIFY ColumnName VARCHAR(255) CHARACTER SET UTF8;