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???
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SagarPosted Jun 18, 2014, 1:07 AM
Anupam SinghPosted Jun 17, 2014, 12:50 PM
and don't put your frustration here.
SagarPosted Jun 17, 2014, 9:38 AM
Anupam SinghPosted Jun 17, 2014, 9:20 AM
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/
SagarPosted Jun 17, 2014, 9:16 AM
SagarPosted Jun 17, 2014, 9:12 AM
Anupam SinghPosted Jun 17, 2014, 1:35 AM
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.