CODEWITHSUNDEEP
phpmysqlcharacter-encodinghindi
DEVOPS
DEVOPS

Reputation: 18790

How to save other languages in mysql table?

Hi I have to save hindi languages in mysql. how can I do that. any one knows the solution please help me.

Upvotes: 7

Views: 10931

Answers (1)

alexn
alexn

Reputation: 59002

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.

Upvotes: 13

Related Questions