Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Sorting of Punjabi Unicode using SQL Server

Author  Topic 

ravish1179
Starting Member

3 Posts

Posted - 2011-02-24 : 01:07:30
I have data in punjabi unicode. These are the names of the districts of the punjab. I want them to display alphabetically in order. Simple order by is not working here. What should I do? please help.

Ravish Kumar

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-02-24 : 03:43:15
send some sample data
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-02-24 : 09:04:53
Try this


select * from yourtable order by districts collate Indic_General_90_CI_AS


PBUH

Go to Top of Page
   

- Advertisement -