How to save Hindi character In MY sql database

Question

3.00/5 (1 vote)

See more:

I am working in a Window Application(C#) and database is MY SQL. In Application I am fetching gmail Inbox and save it in to Database. But My problem is that When I am using Insert Query in code "Subject" or "message" column showing message in Hindi but When Its save in Database Its showing character ???????? like this. I already change all things in utf8 in my sql.

And when I Insert same using My sql editor Its saves in Hindi Font. That's a weird situation for me as I am new to MY SQL.
Can It be problem of Window Application but also there is Utf8 set in app.config file.

Posted 12-Apr-13 3:44am

Neetesh Agarwal

Updated 12-Apr-13 4:32am

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-Apr-13 12:11pm

There is no such thing as "Hindi character". Modern Hindi uses Devanāgarī.
—SA

Sergey Alexandrovich Kryukov 12-Apr-13 12:11pm

What exactly do you mean by "I already change all things in utf8". What things, exactly?
—SA

2 solutions

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)

Abhinav S · Answer 1 · 2013-04-12T04:05:00

Solution 1

You have to setup Collatation on the server.

Some of these links ought to help you -
http://dev.mysql.com/doc/refman/5.0/en/locale-support.html[^]
http://www.yaldex.com/mysql_manual/ch05s10.html[^]
http://dev.mysql.com/doc/refman/4.1/en/locale-support.html[^]

Posted 12-Apr-13 4:05am

Abhinav S

Updated 12-Apr-13 4:06am

v2

Comments

Neetesh Agarwal 12-Apr-13 10:16am

Even its not work.
Tel me should I need to install Hindi fonts on my system.

Sergey Alexandrovich Kryukov 12-Apr-13 12:21pm

It won't help, isn't it obvious?! If you have "???", you don't get a Unicode character already; with a different font, it will remain "???"!

And there is no "Hindi fonts", even if you have some font named like this. All fonts are international. The character repertoire of Devanāgarī is already supported by default by many fonts. You just need to use Unicode and understand what how it works.

Please see my answer and comment to your question.

—SA

Sergey Alexandrovich Kryukov 12-Apr-13 12:17pm

5d. I added my answer, please see.
—SA

Sergey Alexandrovich Kryukov · Answer 2 · 2013-04-12T06:14:00

Solution 2

First of all, you need to use Unicode SQL data type, such as nchar, nvarchar, ntext:
http://msdn.microsoft.com/en-us/library/ms191200%28v=sql.100%29.aspx[^].

Please see my comments to the question.

—SA

Posted 12-Apr-13 6:14am

Sergey Alexandrovich Kryukov

Updated 12-Apr-13 6:15am

v2

Comments

Neetesh Agarwal 13-Apr-13 4:03am

I solved this by using
message = Convert.ToBase64String(Encoding.UTF8.GetBytes(message));
string Normal_message = Encoding.UTF8.GetString(Convert.FromBase64String(message));

Sergey Alexandrovich Kryukov 13-Apr-13 19:20pm

Wrong solution! You need to use Unicode, without transcoding to base64, which is utterly inefficient. By the way, isn't it obvious?
Anyway, you can do whatever you want, but until you learn (among many other things) how Unicode work, don't think you are doing any programming.
—SA

Neetesh Agarwal 15-Apr-13 3:26am

I already did that before this.

Neetesh Agarwal 15-Apr-13 3:30am

I am just started programming one year ago so I am not good programmer yet.

Sergey Alexandrovich Kryukov 15-Apr-13 3:34am

Did you check up that the font shows Devanāgarī? You can use "Charmap.exe".
—SA

Neetesh Agarwal 15-Apr-13 3:48am

No, I not seen that yet but will do. I just make database,table charset utf8 and use Encoding.

Sergey Alexandrovich Kryukov 15-Apr-13 3:50am

Very good. Also see System.Text.Encoding.UTF8 to convert from string to UTF8 and back.
—SA