How to save other languages in mysql table?

php mysql character-encoding hindi
DEVOPS picture DEVOPS · Dec 29, 2010 · Viewed 8.9k times · Source

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

Answer

alexn picture alexn · Dec 29, 2010

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.

Related questions

How to convert these strange characters? (ë, Ã, ì, ù, Ã)

My page often shows things like ë, Ã, ì, ù, à in place of normal characters. I use utf8 for header page and MySQL encode. How does this happen?

Read More
Convert latin1 characters on a UTF8 table into UTF8

Only today I realized that I was missing this in my PHP scripts: mysql_set_charset('utf8'); All my tables are InnoDB, collation "utf8_unicode_ci", and all my VARCHAR columns are "utf8_unicode_ci" as well. I have …

Read More
PDO + MySQL and broken UTF-8 encoding

I use the PDO library with a MySQL database in PHP, but if I insert any data encoded in UTF-8, like Arabic words, it’s inserted into the database, but as ?????????. In my own framework, after I create the PDO …

Read More