Click here to Skip to main content
15,917,862 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi i am storing arabic text in sql server using nvarchar, but its storing arabic text as ???? i don't know how to resolve this , anybody has solution for this?
Posted
Updated 11-Nov-10 18:52pm
v3

Does N'arabic text' make any difference? (N at beginning indicates unicode)
 
Share this answer
 
Comments
sameertm 11-Nov-10 8:51am    
so what i want to do for store arabic text in my database ?"
Indivara 11-Nov-10 8:55am    
That's what I'm telling you. Prefix the text with N, and do what you did before when you got ???? instead of the actual text.
no, N'my arabic text' is not making any change. it put N?????? in database instead
 
Share this answer
 
Comments
Richard MacCutchan 14-Jul-11 4:37am    
Your problem is most likely not with the way the data is stored but with the way you are displaying it when you read it back from the database. Make sure that the actual character type (Unicode or MBCS) is the same at both points, and the font you use to display it can cater for Arabic characters.
How do you know that your arabic text is "stored" as "???????", I believe it is stored in the proper way, your problem is with display of those arabic characters. SSMS may not be able to show you extended unicode characters in the grid. Try to display it on a windows text control or on a web page with a font that supports arabic characters.
 
Share this answer
 
hi you must use Unicode characters instead Arabic (8 bit) characters
convert Arabic chars to Unicode chars and then save string in SQL Server
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900