Case sensitive ??????????

[mooki]

I have installed SS using in-casesensitive sort order.

now i need to use varchar as Case sensitive one.

The problem is that if i change the server to case-sensitive
EVERYTHING becomes case-sensitive including: Table names, column names..... which is BAD for me....

what can i do ?

 

[tlbroadbent]

I assume you are using a SQL Server version prior to SQL 2000. SQL 2000 allows you to specify the collation (sort order) of a column as well as a database. In previous versions the collation is specified for the server so all databases, hence all columns, are the same collation.

In order to achieve a case sensitive sort on a single column in SQL 7 or earlier, you can convert the column to varbinary to sort the column in a case sensitive order.

Example: Case senitive employee name sort

Select * From Employees
Order By convert(varbinary(40), EmpName) Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.