Arabic save record into sql databse

Question

0.00/5 (No votes)

See more:

hi
i have a web application using c# asp.net. when entering arabic names or characters it save them as ???? ??????.

any idea. i change most of fonts for the text box but no success.

thanks in advance

ahmad zrin

Posted 19-Nov-11 5:10am

ahmad zrein

Add a Solution

Comments

Amir Mahfoozi 19-Nov-11 14:37pm

What is the field data type ? if it is nvarchar you will not face any problem.

ahmad zrein 19-Nov-11 21:59pm

yes it is nvarchar

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)

Keith Barrow · Answer 1 · 2011-11-19T05:41:00

Solution 1

It's nothing to do with fonts, the character encoding is going wrong somewhere. The first step is to ensure your Arabic text fields use the correct collation. A pretty good introduction can be found here SQL Server and Arabic Language[^]. You should perform a test inserts directly into the db.
I don't think this will fix *existing* records, but I could well be wrong, my test rig at home won't let me try this easily. Hopefully I am wrong about this.

The other problem you might be having is that your server is interpreting the Arabic in the http request as one of the European encodings. This is less likely, but if you set the default request encoding to utf8, you should be OK.
You only need to check the request encoding if collation thing on the database fails.

Posted 19-Nov-11 5:41am

Keith Barrow

Comments

ahmad zrein 19-Nov-11 12:51pm

yes when insert data directly into the sql database it take arabic correctly. but when i use insert ... Values in c# it save ????

thanks in advance

Keith Barrow 19-Nov-11 15:56pm

Can you clarify the difference between inserting directly and using insert please? In any case, in your position I'd put a breakpoint in your project and check that the text you are trying to insert is coming through as Arabic, just to check the request encoding.

RaviRanjanKr 19-Nov-11 14:56pm

Nice Answer, My 5+

ahmad zrein 19-Nov-11 21:57pm

i mean when open the database from sql design and enter arabic character it takes. while entering data from the program it give ???

Keith Barrow 20-Nov-11 2:51am

You should also try using an INSERT from a TSQL statement, though this should be the same as entering directly IIRC.
As I said, it sounds like the character encoding is changing in the ASP.NET code, you'll need to step through that to determine whether it arrives as Arabic and if it does, where the encoding is changed.