I want to sql server 2008 collation using english as default(in Canada). when search for text, french accent can be ignore.
For example, À,Â,Ä, à, â, ä will be treated same as a or A, but the data still is stored as different(such as for key).
so what is the right collation need to be selected when install sql server 2008?.
If existing instance collation is not the right one, how to change it to the right one?
View Complete Post