Database Multi Language Support Format

Learn how you can create a database that supports Multi languate or UTF-8.

Whenever you create a database or table by default it will create the
characterset to latin1 which is only supports english character and for
other non english character it wont support.

database icon

To support multilingual you need set UTF-8 character set to all your table and database.

Go to your schema or database properties and change the collation or charset
to UTF-8

or

Alter database databasename charset=utf8;

Go to your table properties and alter the collation or charset to UTF-8

or

Alter table tablename charset=utf8;

Alter table tablename alter column columnname charset=utf=8;

After altering all table now you can able to insert any format of data without being corrupted.

That's It...

Popular posts from this blog

Five More Indian Languages - Google Translate