Storing and displaying unicode string (हिन्दी) using PHP and MySQL

by

Did you set proper charset in the HTML Head section?

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

or you can set content type in your php script using – 

   header( 'Content-Type: text/html; charset=utf-8' );

There are already some discussions here on StackOverflow – please have a look

How to make MySQL handle UTF-8 properly
setting utf8 with mysql through php

PHP/MySQL with encoding problems

So what i want to know is how can i
directly store सूर्योदय into my
database and fetch it and display in
my webpage using PHP.

I am not sure what you mean by “directly storing in the database” .. did you mean entering data using PhpMyAdmin or any other similar tool? If yes, I have tried using PhpMyAdmin to input unicode data, so it has worked fine for me – You could try inputting data using phpmyadmin and retrieve it using a php script to confirm. If you need to submit data via a Php script just set the NAMES and CHARACTER SET when you create mysql connection, before execute insert queries, and when you select data. Have a look at the above posts to find the syntax. Hope it helps.

** UPDATE **
Just fixed some typos etc

More Related Contents:

  1. Fixing broken UTF-8 encoding
  2. UTF-8 all the way through
  3. How to decode Unicode escape sequences like “\u00ed” to proper UTF-8 encoded characters?
  4. Reference: Why are my “special” Unicode characters encoded weird using json_encode?
  5. SET NAMES utf8 in MySQL?
  6. MySQL and PHP: UTF-8 with Cyrillic characters [duplicate]
  7. preg_match and UTF-8 in PHP
  8. Whether to use “SET NAMES”
  9. Convert latin1 characters on a UTF8 table into UTF8
  10. PHP: Convert unicode codepoint to UTF-8
  11. Best practice multi language website
  12. UTF-8 to Unicode Code Points
  13. How to store the data in unicode in hindi language
  14. can I get the unicode value of a character or vise versa with php?
  15. Trim unicode whitespace in PHP 5.2
  16. How to display Unicode data with PHP [duplicate]
  17. strlen() and UTF-8 encoding
  18. Is “SET CHARACTER SET utf8” necessary?
  19. UTF-8 not working in HTML forms
  20. The ultimate emoji encoding scheme
  21. Is a BLOB converted using the current/default charset in MySQL?
  22. Send emails with international accent and special characters
  23. UTF8 Filenames in PHP and Different Unicode Encodings
  24. Trim unicode whitespace in PHP
  25. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  26. The holy grail of cleaning input and output in php?
  27. MySQL: Select Random Entry, but Weight Towards Certain Entries
  28. Multiple mysql INSERT statements in one query php [duplicate]
  29. Is mysql_real_escape_string enough to Anti SQL Injection?
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment