How to save other languages in mysql table?

Hi I have to save h开发者_Go百科indi languages in mysql. how can I do that. any one knows the solution please help me.

You need to store all text as UTF8, then you'll be able to see Hindi characters. You can update a column to use UTF8 with a query like the following:

ALTER TABLE posts MODIFY title VARCHAR(255) CHARACTER SET UTF8;

Since you use PHP, make sure that all your PHP scripts are saved as UTF8. You can also set the connection charset with the following query:

SET NAMES 'utf8'

This will ensure that your web server and database servers communicate using UTF8.