January 6, 2002 at 10:58 pm
What Collation Name should I select so that I can sort data in Hindi Alphabetical Order.
January 7, 2002 at 10:14 am
I'd assume this is it:
Windows locale LCID
(locale ID)
Collation designator Code page
Hindi 0x439 Hindi Unicode only
If it isn't there, you will probably have to check with MS.
From:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_collation_6gfn.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2e95.asp
Steve Jones
January 7, 2002 at 10:41 pm
quote:
I'd assume this is it:Windows locale LCID
(locale ID)
Collation designator Code page
Hindi 0x439 Hindi Unicode only
If it isn't there, you will probably have to check with MS.
From:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_collation_6gfn.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2e95.asp
Steve Jones
Thanks for the solution, but I think it does not work.
I cannot assign the Hindi Collation designator at database level. When I asign it at column level, I am not able to sort the data as per hindi alphabets. It is sorted in some different way.
January 8, 2002 at 10:45 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply