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

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

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