|
|
Posted by Erland Sommarskog on 08/18/05 00:59
aki999 (aki999@wp.pl) writes:
> We need to install CI database on CS server, and there are some issues
> DECLARE @ID INT (here @ID in uppercase)
> SELECT @id=CustomerID FROM Customer WHERE .... (here @id in lowercase)
>
> I know @ID is not equal to @id in CS, but database is CI and table
> names Customer and CUSTOMER both works. This does not work for
> variables.
>
> I suppose it is tempdb collation problem (CS like a server collation
> is). I tried a property "Identifier Case Sensitivity" for my
> connection, but it is read only and have value 8 (Mixed) by default -
> this is OK I think.
>
> DO I MISS SOMETHING ????
I will have to admit that I was under the impression that it was the
database collation that controlled the sensitivity of variables,
but apparently it is the system collation, so it appears that you
will have to install a case-insensitive instance, assuming that the
code you have problems with is in stored procedures.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|