Last post Nov 30, 2006 11:38 PM by Caddre
Nov 28, 2006 07:51 AM|faisalmk|LINK
I have developed an application in asp3.0 using Unicode with
charset=utf-8 . My native language
is urdu and I developed the application in
urdu the data present in data base is in this format Ø¨ÛŒÙ†
when I am fetching this data on asp3.0 page I am using metatag <Meta http-equiv="Content-Type" content="text/html;
charset=utf-8"> its display the
desired result what I want as بین الاقوامی خبریں
Now I am going to upgrade this application with asp.net 1.3 I make an interface to enter the data in database and the data enter the database
is in format of بین الاقوامی خبریں
instead of Ø¨ÛŒÙ† Ø§Ù„Ø§Ù‚ÙˆØ§Ù…ÛŒ
Ø®Ø¨Ø±ÛŒÚº when I am fetching this data on asp.net it’s showing correctly but when I am fetching this data on asp3.0 its showing me ?????????
in the similar way when I am fetching the data enter by asp3.0 in asp.net is showing as it is reside in database i.e Ø¨ÛŒÙ† Ø§Ù„Ø§Ù‚ÙˆØ§Ù…ÛŒ
not showing بین الاقوامی خبریں
Anyone help me what I do to access my all records over 30,000 in asp.net with correct format
Nov 28, 2006 12:04 PM|Caddre|LINK
There is a locale ID defined for Urdu in Windows you will find it in the first link, the second link shows you how to save you code with encoding and let you choose the editor to use so you can avoid character conversion. VS2005 advanced option let you
save your code with the Urdu code page in Windows. If you do all of the above you will avoid character conversion.
This last link will help you understand Unicode encoding and how to use it in your application layer. Hope this helps.
Nov 29, 2006 06:44 AM|faisalmk|LINK
Nov 29, 2006 10:36 AM|Caddre|LINK
If you are in SQL Server 2000 and above you need to do column level collation for you data, encoding for the application layer and language specific collation in the database will remove your charater conversion you are getting now.
Here is what you need make your text unicode by using Nvarchar, Nchar, NText, Nvarchar (max) and Nchar (max) with Arabic column level collation and your character conversion will go away. I have helped thousands I have not seen any that it did not help.
Post again if you still have question.
Nov 30, 2006 01:19 AM|faisalmk|LINK
Nov 30, 2006 11:38 PM|Caddre|LINK