Raghavendra Mudugal (2/27/2013)
(note : I know (and most of all know) collation is very important and each server/database/table or any object which is qualified for using collation has one by default whether or not we set it explicitly and result of the underlying task depends on it... I am not arguing that it must not be used or mentioned... but when the collation is not mentioned by the author in any qtod lets take it as the default say "Latin1_General_CI_AI"; mentioning the collation and its varied results in every qtod's reply is really... (dont know why it is bothering me...)... and i know now you all have a lot to say on this and like i said "i am not arguing here" its just the same replies to qtod.. kind of old gig now.. and I apologize if I offended anyone with this comment, it is not intentional; it is in general)
I agree, no need to mention the collation when it's the default collation (although some will always complain).
However, the default isn't Latin1_General_CI_AI, it's case insensitive. But it's accent sensitive - CI_AS
edit: add missing bit, so it makes sense