Default Collation depends on..??

Posted by Vasanthmvp under Sql Server on 11/3/2012 | Points: 10 | Views : 1148 | Status : [Member] | Replies : 1
Does the default value of a column collation depends on the windows o.s language that we set..??
Should we consider this too while creating a column.. or explicitly only in cases where search techniques are implemented..


Awesome Coding !! :)


Posted by: Saratvaddilli on: 11/4/2012 [Member] [MVP] Bronze | Points: 25

hi vasanthmvp,
i think it depends upon the language which we set because SQL Server setup inspects the server locale during install and selects a collation based on the regional settings. It is important to set these correctly during OS deployment!

Thanks and Regards
Show difficulties that how difficult you are

Vasanthmvp, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response