1. Check your column datatype it should be NVarchar
2. While inserting the value the string constants should be enclosed with N'....'
3. If the above 2 points are not solving your problem, then create the column with rite collate..
create table #test
(
alphas nvarchar(1) Collate Turkish_CI_AI
)
insert into #test values(N'A');
insert into #test values(N'D');
insert into #test values(N'Y');
insert into #test values(N'?');
insert into #test values(N'?');
insert into #test values(N'?');
insert into #test values(N'ü');
Select alphas from #test Order By alphas Desc
No comments:
Post a Comment