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 2000 Forums
 SQL Server Development (2000)
 Unicode sort

Author  Topic 

noamg
Posting Yak Master

215 Posts

Posted - 2006-10-30 : 11:53:53
hi,
I run the following, but the result show char-224 before char-65 !!!

create table ling( str nvarchar(1000))

insert into ling values( N'Ann Smith')
insert into ling values( N'Anna')
insert into ling values( N'Becky')
insert into ling values( N'Clara')
insert into ling values( N'Deanna')
insert into ling values( N'#913;#961;#953;#963;#964;#959;#964;#941;#955;#951;#962;')
insert into ling values( N'#1040;#1083;#1077;#1082;#1089;#1072;#1085;#1076;#1088;#1072;')
insert into ling values( N'à#262;Æ')
insert into ling values( N'DF#282;è')
insert into ling values( N'Zxr')
insert into ling values( N'89')
insert into ling values( N'#&^')
-----------------

select * from ling
order by str asc



Noam Graizer

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-30 : 12:03:54
this is because of collation settings
try:
create table ling( str nvarchar(1000) collate Latin1_General_BIN)

for all collations see
SELECT * FROM ::fn_helpcollations()



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-30 : 12:13:56
Or just sort them collated when using the records in the output, as
select * from ling
order by [str] collate Latin1_General_BIN


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -