How to store the data in unicode in hindi language

by

Choose utf8 character set and utf8_general_ci collation.

Obviously, Collation of the field (to which you want to store Hindi text) should be utf8_general_ci.

To alter your table field, run

ALTER TABLE `<table_name>` CHANGE `<field_name>` `<field_name>` VARCHAR(100) 
CHARSET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL;

Once you’ve connected to database, run the following statement at first

mysql_set_charset('utf8');

Eg:

//setting character set
mysql_set_charset('utf8');

//insert Hindi text
mysql_query("INSERT INTO ....");

To retrieve data

//setting character set
mysql_set_charset('utf8');

//select Hindi text
mysql_query("SELECT * FROM ....");

Before you printing any unicode text (say Hindi text) on browser, you should have to set content type of that page by adding a meta tag

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

Eg:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Example Unicode</title>
</head>

<body>
<?php echo $hindiText; ?>
</body>
</html>

Update:

mysql_query("SET CHARACTER SET utf8") has changed tomysql_set_charset(‘utf8’);
This is the preferred way to change the charset. Using mysql_query() to set it (such as SET NAMES utf8) is not recommended. See http://php.net/manual/en/function.mysql-set-charset.php*

More Related Contents:

  1. Fixing broken UTF-8 encoding
  2. Storing and displaying unicode string (हिन्दी) using PHP and MySQL
  3. How to display Unicode data with PHP [duplicate]
  4. how to write php code for the key press enter button when fill the form?
  5. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  6. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  7. How to run deprecated php codes on the latest XAMPP [duplicate]
  8. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  9. Is closing the mysql connection important?
  10. Shortcomings of mysql_real_escape_string?
  11. Alternative to mysql_real_escape_string without connecting to DB
  12. HTML – Change\Update page contents without refreshing\reloading the page
  13. Create a dynamic mysql query using php variables
  14. How to enable mysqlnd for php?
  15. Mysql event error using php
  16. How to separate DATE and TIME from DATETIME in MySQL?
  17. How do I count unique visitors to my site?
  18. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  19. ini_set, set_time_limit, (max_execution_time) – not working
  20. What is the best way to insert multiple rows in PHP PDO MYSQL?
  21. Fatal error: Call to undefined function mysqli_result()
  22. access denied for user @ ‘localhost’ to database ” [closed]
  23. How can I employ “if exists” for creating or dropping an index in MySQL?
  24. PHP MySQL pagination with random ordering
  25. How to backup MySQL database in PHP?
  26. Create PHP array from MySQL column
  27. Convert Time String to Decimal Hours PHP [closed]
  28. How do i search from serialize field in mysql database?
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment