Hi all,

I am using ASP.NET (Visual Basic as code behind). I have a page Article.aspx on my website. Here i have incorporated TinyMCE Editor Control and i am saving its content to an SQLServer Express 2005 database. The data movement is fine. and i am using ASP.NET Label Control to display these contents back to my users. Things are fine.

Now i have installed BBC Urdu Font on my system and i was able to type urdu language in MS WORD. I typed some articles using urdu font and then i copied and paste those writings to my Article Page (In TinyMCE Editor). But when i click save button. The Display of those what is written in english language is fine, but the urdu lanauge didnot display correctly. instead it shows me ?????????????  like that on the page.

اردو ٹاۂپنگ

i start searching internet and i found some thing that UTF/UTF encoded binary could be used to save the data in database. But that post is incomplete and it leads to no where.

So i was thinking if some body could help me in some direction. Some Link etc. would be great help.

Once again the data (TinyMCE Editor) could be entirely URDU, Entierly English  (which is working fine) or a mixmode (English, Urdu mix).

Hi,

To support urdu language your page should support specific encoding e.g. UTF-8, UTF-16, Unicode etc.

Please refer below link for more information-

http://msdn.microsoft.com/en-us/goglobal/bb688110.aspx

Thank you for your reply. i have followed the link, but it seems a general guide for localization. i would prefer if you can guide me towards some results oriented link specific to asp.net.

i tried to support unicode in my webpaga by adding

<meta content="text/html;charset=UTF-16" http-equiv=content-type />

just check link for urdu example :-

Yes Manoj, it was more specific article. But i believe i will need it in future. currently i only need to store my text as urdu langauge. i dont need to localize the controls. i mean i want that if i write (copy from msworld) urdu text in textbox. it should display back as urdu text using some label control etc., thats it.

in that case, of ASP.NET IDE. from File option select Advance Save Options then from first drop down list (Encoding) select 3rd option that is Unicode - Codepage 1200. and save it. should work.  even I did arabic project so i know this should work for you.

File --> Advance Save Option --> Select from drop down list (Unicode - Codepage 1200)

I believe there is some misunderstanding. I am talking about something related to database. The urdu text shall be typed/copied in text area of TinyMCE text box and it is bound to some database. when later it shall be displayed using some label or text control. it should display same urdu text what i inserted earlier.

I think it is clear now. If you go through my post from the begining then it will be more clear.

ya, may be I miss read question

two thing to note about is.

1) your data type should be Nvarchar

2) when you do query prefix it with N

below things just check it, you will get idea :)

declare @T nvarchar(50)

set @T=N'احتياجات '

select @T

1) your data type should be Nvarchar

you made my day dear, it solve my problem and now it is storing and displaying it perfectly, i didnot check the editmode yet, but i believe there shall be no problem in that mode. Thanks again for your time and help.

Regards,

happy to help :)

I worked 2 years in Arabic projects. so I know this stuff.

I am afraid with nvarchar we might still need to set up text collation when installing the database, because I see a bunch "???????" in an nvarchar field of a sql table where some Chinese characters have been entered.