August 29, 2013 at 7:57 am
L' Eomot Inversé (8/29/2013)
Good question.... in case sensitive collations ''sysygy' would sort before 'Sally', but in practice it sorts after 'Sally' regardless of whether the collation is case sensitive or not ...
That is interesting! I did some test, to make sure I understand correctly and I got different answer depending if I specify collation or remove the "order by 1".
insert #test ( name ) values ( 'syst');
insert #test ( name ) values ( 'Sally');
insert #test ( name ) values ( 'sally');
insert #test ( name ) values ( 'Syst');
insert #test ( name ) values ( 'Soap');
insert #test ( name ) values ( 'soap');
Case 1: create table #test(name varchar(10) COLLATE Latin1_General_CS_AS);
sally
Sally
soap
Soap
syst
Syst
Case 2: same as Case1 but with no Collate
Sally
sally
Soap
soap
Syst
syst (Hugo, here is your proof that you can't rely on the order that data has been entered!)
Case 3: same as Case 1 but removed the "order by 1" (result is as the data has been entered)
syst
Sally
sally
Syst
Soap
soap
Never stop learning! Thanks!
August 29, 2013 at 8:26 am
Ed Wagner (8/29/2013)
In the ASCII character set [...] A is 65 while a is 97. To have them sort differently here is somewhat counter-intuitive [...].Don't get me wrong here, I like that lower case sorts ahead of upper case...it's just different.
+1, except for the fact that I don't like it. 🙂
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
September 4, 2013 at 4:20 am
Hugo Kornelis (8/29/2013)
I decided to rely on my memory of lowercase/uppercase order instead of double checking. Bad decision. 😉
Ditto.
September 5, 2013 at 6:41 am
Good question. Brushed up things on sorting. 🙂
September 7, 2013 at 5:46 am
very very tough 🙂
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply