Eric,

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

Answers

Vasudha,

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,

Eric

-- Anonymous, June 14, 2000