MS SQL Server - case sensitive collation issues

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

case sensitive collation issues

Jack Vamvas

2006-10-24, 6:38 pm

I have a db - DB1 = Collation=SQL_Latin1
_General_CP1_CI_AS, SQLSortOrder=52
It's sitting on a server Collation = Latin1_General_BIN
The tempdb = Latin1_General_BIN

Note: I created the db from scratch on the server

When I run the following

CREATE PROCEDURE test
AS
DECALRE @test VARCHAR(1)
SELECT @TEST

Error = Server: Msg 137, Level 15, State 2, Procedure test, Line 5
Must declare the variable '@TEST'.

If I change the SELECT @TEST to SELECT @test it works fine.

It looks like it's a case issue , I thought the the db setting overrides the
the server setting and that any new objects created inherited the db
collation levels ?

Sponsored Links