Case senstivity in data : LUSENET : SQL Server Database Administration : One Thread


I am pretty sure the answer to this is 'no', but I just had to check with you. Can the sort order be different in databases under the same sql server? I have a sql server, installed with a dictionary order, case-sensitive. There are 2 dbs under this server - One of them needs to be case-sensitive, but the other does not. Is this possible to implement? Is there any work-around to this?

Thanks, Vasudha

-- Anonymous, June 14, 2000



Indeed the answer is 'no'. The SQL Server Books Online article, "Sort Order" clearly states, "You cannot have different databases with different sort orders on the same server."

To obtain some degreee of case sensitivity, you can convert a string to binary before doing a comparison or ORDER BY clause.

Hope this helps,


-- Anonymous, June 14, 2000

Moderation questions? read the FAQ