SQL Server Performance Forum – Threads Archive
Default Sort orderHi All, I’m new to SQL Server & I have been asked to install <br />SQL 2000 with a default sort order ID of 52. I’m not too sure how to go about this.<br />I have chosen the custom install and I’m stuck at the Collation settings. <br />I have had a look around but I not sure which to choose.<br /><br />Any help wuold be much appreciated.[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />Vic
If the application data doesn’t have any specific requirement such as storing foreign data or data to be stored other than english, then choose compatible collation. Change the default settings for Windows Locale (Windows collation) only if your installation of SQL Server must match the collation settings used by another instance of SQL Server 2000, or must match the Windows locale of another computer. Select the name of a specific Windows collation from the list, for example:
–Use Latin1_General for the U.S. English character set (code page 1252).
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.