How to insert Hindi language in Mysql

by

The charset of the database needs to be utf8_unicode_ci.

Try creating a new database, as well as a new table.

CREATE DATABASE hindi_test
    CHARACTER SET utf8
    COLLATE utf8_unicode_ci;

USE hindi_test;

CREATE TABLE `hindi` (
    `data` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `hindi` (`data`) VALUES
    ('कंप्यूटर');

This works on my install. If it doesn’t work for you, something might be wrong with your server settings.

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  3. How can I temporarily disable a foreign key constraint in MySQL?
  4. How to do a batch insert in MySQL
  5. Get current AUTO_INCREMENT value for any table
  6. Creating a “Numbers Table” in MySQL
  7. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  8. Determine which MySQL configuration file is being used
  9. Rails, MySQL and Snow Leopard
  10. In SQL, how to select the top 2 rows for each group
  11. MySQL CONVERT_TZ()
  12. MySQL: #126 – Incorrect key file for table
  13. MYSQL Left Join COUNTS from multiple tables
  14. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  15. Finding number position in string
  16. Why does MySQL autoincrement increase on failed inserts?
  17. Case Sensitive collation in MySQL
  18. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  19. Getting first day of the week in MySql using Week No
  20. Can’t import database through phpmyadmin file size too large
  21. error code 1292 incorrect date value mysql
  22. How to search for rows containing a substring?
  23. Import CSV to Update only one column in table
  24. MySQL : how to remove double or more spaces from a string?
  25. Mysql returning clause equivalent
  26. Error in MySQL library for Node.js
  27. GRANT with database name wildcard in MySQL?
  28. Using SUM on FLOAT data
  29. Composite Primary Key performance drawback in MySQL
  30. SQL query with avg and group by

Leave a Comment