<div>
Updated: &nbsp;Need the collation sequence to be &quot;&nbsp;Latin 1 binary&quot;. &nbsp;Is this the default or do I need to configure during setup?<br />
<br />
Thanks, <br />
<br />
LMar
</div>


Updated:  Need the collation sequence to be " Latin 1 binary".  Is this the default or do I need to configure during setup?

Thanks,

LMar

<div>
Nevermind - found it. &nbsp;The setting is available when the DB is created. <br />
<br />
LMar
</div>


Nevermind - found it.  The setting is available when the DB is created.

LMar

<div>
Yes, but then the server default and the db will be different collations. &nbsp;That is a real pain. &nbsp;Personally I would uninstall and re-install using the desired collation [unless that collation will only be for one db] -- it will make things much easier in the future.
</div>


Yes, but then the server default and the db will be different collations.  That is a real pain.  Personally I would uninstall and re-install using the desired collation [unless that collation will only be for one db] -- it will make things much easier in the future.

<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
I have a new SQL server and I need the sort order to be set to: &quot;Binary Order, case sensitive&quot;. &nbsp;How do I go about doing this? &nbsp;Reinstallation is no problem as it's a fresh installation of SQL2000. <br />
<br />
Thanks, <br />
<br />
LMar
</div>
</div>


Hello, 

I have a new SQL server and I need the sort order to be set to: "Binary Order, case sensitive".  How do I go about doing this?  Reinstallation is no problem as it's a fresh installation of SQL2000. 

Thanks, 

LMar

Set SQL 2000 Sort Order to &quot;Binary Order, case sensitive&quot;

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Set SQL 2000 Sort Order to &quot;Binary Order, case sensitive&quot;

Set SQL 2000 Sort Order to "Binary Order, case sensitive"