how to store hindi text in mysql

Question

3.86/5 (3 votes)

See more:

ASP.NET

MySQL

how to store hindi text in mysql

Posted 10-Apr-13 21:35pm

ujali

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sudhakar Shinde · Accepted Answer · 2013-04-10T21:55:00

Solution 1

Please find below steps to store and retrieve hindi text.
1) Choose utf8 character set and utf8_general_ci collation.
2) Whenever you want to save and retrieve the data you need to set the characterset as follows.

SQL

//To set the char set
mysql_set_charset('utf8');

//To select hindi data
mysql_query("SELECT * FROM ....");

// To insert hindi data
mysql_query("INSERT INTO ....");

Before you display hindi content in your browser set content type of that page using meta tag.

PHP

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

Posted 10-Apr-13 21:55pm

Sudhakar Shinde

Updated 10-Apr-13 22:00pm

v3

Comments

ujali 11-Apr-13 4:04am

i tried this ..but while i am editing something in that coloumn in mysql in hindi language ,it is taking ??? this value or storing this value.

Sudhakar Shinde 11-Apr-13 4:11am

How are you editing the data? Does your editor supports UTF-8 character set?

ujali 11-Apr-13 4:28am

simply by typing text in colounm in hindi,not typing,i just copy hindi text in colounm and run the table,how to check that my editor supports UTF-8 character set

Neetesh Agarwal 11-Apr-13 4:06am

Hello SRSHINDE, I am fetchimg Gmail Inbox and need to store data in my-Sql but soe times mail is hindi , some times in English then how to manage this. Please Reply

Thanks

Sudhakar Shinde 11-Apr-13 4:15am

What is character set and collation of your database? You need to follow above steps to store hindi messages in the database.

Neetesh Agarwal 11-Apr-13 4:17am

Ok, But Will It also include English message ? Bcz Mail can be Either in Hindi or in English

Sudhakar Shinde 11-Apr-13 4:20am

Yes..UTF-8 stores English messages also.

Neetesh Agarwal 11-Apr-13 4:19am

ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8$$

Sudhakar Shinde 11-Apr-13 4:23am

ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8

Neetesh Agarwal 11-Apr-13 4:29am

Thanks......

ujali 11-Apr-13 4:20am

simply by typing text in colounm in hindi,not typing,i just copy hindi text in colounm and run the table,how to check that my editor supports UTF-8 character set

Sudhakar Shinde 11-Apr-13 5:32am

Please check this link (http://bugs.mysql.com/bug.php?id=54652)

Sudhakar Shinde 11-Apr-13 6:37am

Neetesh was able to save and view the data successfully in hindi. You need to ensure that you are saving data in UTF-8 mode and creating tables with UTF-8 character set.

Neetesh Agarwal 11-Apr-13 5:20am

When I am using this this errors shown.

Error Code: 1366. Incorrect string value: '\xE0\xA4\x97\xE0\xA5\x8D...' for column 'description' at row 1

Sudhakar Shinde 11-Apr-13 5:25am

How are you using it? Please paste the entire script.

Neetesh Agarwal 11-Apr-13 5:30am

I have two tables. In one Its working but in another one its not working showing this error.

Neetesh Agarwal 11-Apr-13 5:31am

INSERT INTO `ghm`.`incident3`
(`item_id`,
`subject`,
`team_member`,
`types_of_graphics`,
`department`,
`graphics_type`,
`item_mode`,
`in_time`,
`out_time`,
`status`,
`priority`,
`description`,
`flag`)
VALUES
(
'GHM0000000001',
'Checking Hindi',
'Aman Dua',
'Online',
'News',
'End Plate',
'Phone',
'09/04/2013 10:04:31 PM',
'09/04/2013 10:04:31 PM',
'New',
'Low',

'नकद अतंरण योजना

-----------------------

-अगले मार्च तक पूरे देश में लागू किया जाएगा

-योजना का दूसरा चरण एक जुलाई से शुरू होना है। इस चरण में 19 राज्यों तथा दो केंद्र शासित प्रदेश शामिल

--दूसरे चरण में 78 जिलों में डीबीटी योजना के लिये बुनियादी ढांचा 31 मई तक पूरा करने का लक्ष्य

-पहला चरण एक जनवरी से 43 जिलों में शुरू किया गया था ,

-देशभर के 20 जिलों में रसोई गैस सब्सिडी को 15 मई से डीबीटी योजना में शामिल किया जाएगा।

,
0
);

Sudhakar Shinde 11-Apr-13 5:38am

Please read (http://forums.mysql.com/read.php?103,154519,154519#msg-154519) for the resolution.

Neetesh Agarwal 11-Apr-13 6:16am

Thanks , Its working Now.
The problem was while creating Table its by default character set was Latin.

Sudhakar Shinde 11-Apr-13 6:22am

Thanks ..I will put this as an answer to your query. Please accept it.

Neetesh Agarwal 11-Apr-13 7:07am

Yeah , Thanks