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.
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 lingorder by str ascNoam Graizer |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-30 : 12:03:54
|
this is because of collation settingstry: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 |
|
|
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, asselect * from lingorder by [str] collate Latin1_General_BIN Peter LarssonHelsingborg, Sweden |
|
|
|
|
|