SOrting Data

Question

from WPF UI i m Saving hindi text values in table in nvarchar columns and need to retrieve these values in Sorted order in hindi ???? wat to do???

Sagar · Answer

Mr Anupam I was asking so frequently bcoz u wre replying & i thought u r interested in my problem u could say no if u hv no idea but y r u getting irritated ... chill

Sagar · Answer

Catuaaly everything(insertdeleteSHow data in Datagrid) is happening fine but the only problem is m unable to sort data according to  hindi Varnmala k kha ga gha ... getting me???

Anupam Singh · Answer

read this article : http://aalamrangi.wordpress.com/2012/05/13/storing-and-retrieving-non-english-unicode-characters-hindi-czech-arabic-etc-in-sql-server/ there is an alternate option here : http://www.c-sharpcorner.com/uploadfile/eb5fab/insert-hindi-font-in-Asp-Net-web-page-to-sql-database/

Sagar · Answer

i tried wat u replied but really its nt working do u hv another way by the way thanx for ur previous answers

Sagar · Answer

still its not working

Anupam Singh · Answer

Hi jain; try inserting value using prefix N in nvarchar column. ex. suppose you have Hindi table with 2 nvarchar column. then INSERT INTO Hindi VALUES(N'??????' N'???????') select query will remain same.

Anupam Singh · Answer

You cant. and don't put your frustration here.