How Can I Insert My Urdu Text In Mysql Data Base ?

Question

0.00/5 (No votes)

See more:

i am using varchar type of field and manully it allows to insert urdu text but when i add it by form then ???? value are inserted in the table fields are ?????? how can i proper inserted it

Posted 15-Sep-14 6:56am

Asim Shahid

Updated 14-Sep-20 21:36pm

Add a Solution

4 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)

mhegazy94 · Answer 1 · 2014-09-16T19:39:00

Solution 4

try using this

SQL

VARCHAR(n) CHARSET ucs2

Posted 16-Sep-14 19:39pm

mhegazy94

Faizanamjad · Answer 2 · 2014-09-15T08:09:00

Solution 1

Hi

Varchar type of field allow you insert any type of data in database it will easily save your Form Field either you are writing in English, Urdu , Arabic etc.

Posted 15-Sep-14 8:09am

Faizanamjad

Afzaal Ahmad Zeeshan · Answer 3 · 2014-09-15T09:37:00

Solution 2

Urdu has a different encoding and decoding of the string data and thus when saving it the data must be saved in a form that once extract it must be the same Urdu encoding for you to get.

The only thing you should do is, if the database isn't allowing any setting and you're still getting this error, then try saving the bytes of the data.

But remember, Unicode encoding is the only encoding that allows the worldly languages, other character sets allow only English. That is why, your entire encoding of character set must be changed to Unicode. It is the same encoding that is set for the HTML document etc. This tells the environment (software application) that the document that is provided is/and must be formatted according to the Unicode standards.

Posted 15-Sep-14 9:37am

Afzaal Ahmad Zeeshan

Updated 15-Sep-14 19:29pm

v2

Comments

Sergey Alexandrovich Kryukov 15-Sep-14 23:49pm

There is no such thing as "UTF encoding". There are several UTFs. Well, perhaps this is just inaccurate wording.
But the statement about non-UTF (more correctly, encodings not based on Unicode) — only English — is absolutely not true.
—SA

Afzaal Ahmad Zeeshan 16-Sep-14 1:20am

Ok, so how will you explain this function in .Net Framework.

byte[] bytes = new UTF8Encoding(true).GetBytes("love for all, hatred for none!");

..let me tell. This means, that the bytes to get from the string, is written in UTF-8 encoding. Hopefully, I might have missed a point in explaining this function.

Afzaal Ahmad Zeeshan 16-Sep-14 1:22am

However, agree to be wrong. :-) I didn't mean UTF at itself, it was the unicode..silly me!

Sergey Alexandrovich Kryukov 16-Sep-14 1:51am

As I assumed, it was just awkward warning, but it's better to work the way not confusing some less experienced readers.
Bigger problem is other, non-Unicode encodings. The principles are different, but there are many non-Unicode encodings supporting non-English characters. In most cases, they support Latin + some other script.
—SA

Asim Shahid 15-Sep-14 23:51pm

kindly guide me how can i tell my software application that the document that is provided must be formatted according to the utf standards ??

Afzaal Ahmad Zeeshan 16-Sep-14 1:21am

Have a look at the comment above. That has the functionality to convert the string to byte array and then you can save it.

Sergey Alexandrovich Kryukov 16-Sep-14 1:54am

Usually, you don't need anything special. If you save all your textual artifacts as UTF-8 and read in this encoding, it will cover all scripts supported by Unicode, and .NET already fully supports Unicode. The only remaining problem would be MySQL support; I answered in Solution 3.

And you need to understand the principles of Unicode.

—SA

Asim Shahid 23-Sep-14 6:45am

string query = "INSERT INTO book VALUES('";
query = query + textBox1.Text+ "','";
query = query +textBox2.Text+ "','";
query = query +textBox3.Text + "','";
query = query +textBox4.Text + "')";
cmd = new MySqlCommand(query, con);
MySqlDataReader d = cmd.ExecuteReader();
MessageBox.Show("complete");
d.Close();
i am using this query i know its have a chance of sql injection attack but kindly tell me how can i insert my urdu text with this query as when i write English it properly inserted but when my text field have urdu text it inserted ????? at the column. kinldy guide me. my column type is varchar(45) and collations is utf8 genral ci

Afzaal Ahmad Zeeshan 23-Sep-14 10:13am

That is a clear sign on the format not supported. Are you sure you're using Unicode?

Asim Shahid 23-Sep-14 15:44pm

i am not sure.. how can i sure it?

Sergey Alexandrovich Kryukov · Answer 4 · 2014-09-15T17:58:00

Solution 3

To support Urdu, you need Unicode support. .NET is totally based on Unicode; and you need to take care of MySQL support.
Please read this part of MySQL documentation: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html[^].

Note that only the BMP is supported, but all code points used by Urdu are in BMP: http://en.wikipedia.org/wiki/Urdu_alphabet[^].

See also: http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html[^].

—SA

Posted 15-Sep-14 17:58pm

Sergey Alexandrovich Kryukov

Comments

[no name] 16-Sep-14 7:40am

using nVarchar type allow to add text writing in Arabic, English and Urdu.

Sergey Alexandrovich Kryukov 16-Sep-14 9:43am

Correct, but there this type is available.
In MySQL, however, it could be
VARCHAR(n) CHARSET utf8.
—SA

[no name] 17-Sep-14 1:39am

use this
VARCHAR(n) CHARSET ucs2

Sergey Alexandrovich Kryukov 17-Sep-14 1:52am

Why not utf8?
—SA