comparing hindi and other language words

In tables involving multiple languages use a character set suitable for multiple languages like utf8.

This can be specified while creating tables or can be altered after creating tables.

To alter the character set of an existing table use the following command.

alter table cont CONVERT TO CHARACTER SET 'utf8';

This will set the character set of the table to utf8.