Re: very simple query but wrong. WHY ?

From: WangKhar (Wangkhar_at_yahoo.com)
Date: 06/10/04 

Date: 10 Jun 2004 02:47:53 -0700

Variables case sensitivity is determined by the master db collation I
believe - or the server anyway.

You have installed it as
Server collation: Latin1_general_Bin

teh binary ie everything sensitive collation. Either rebuild master -
or reinstall with a different, non CS collation, or suck up the
discipline...

g'luck.

paolo.gabbi@edpsistem.it (PGA) wrote in message news:<e92bc2c7.0406090607.6cceeab9@posting.google.com>...
> Hi.
> I wrote a query that doesn't work at all. Lets me write it.
>
> -------------------------------
> declare @mm as int -- variable @mm WRITE DOWN IN LOWERCASE
> set @MM = 1 -- same variable @mm WRITE DOWN IN UPPERCASE
> print @mm
> -------------------------------
>
> running query I got the message
> Server: Msg 137, Level 15, State 1, Line 3
> Must declare the variable '@MM'
>
> Obviously If I write down variable always uppercase or lowercase it work well.
>
> I run SQL2000 SP.2 (8.00.534) standard edition,
> Language: English (United States)
> Server collation: Latin1_general_Bin
> on platform Windows 2003 Italiano (Win NT 5.2 (3790))
>
> I got the error as well I run the query on db created with default
> Collation as on db created with Collation Latin1_General_CI_AI
> (case insensitive, accent insensitive).
>
> This is for me a big problem because involve about a hundred of Stored proc
> Any one have a idea to solve this ?
>
> Thanks a lot. PAOLO

Relevant Pages

  • Re: Could not find stored procedure - But its there.
    ... But any Stored Procedure using variable names, will be case sensitive if the server collation is case sensitive, so are transaction scope names. ... not the collation of the database itself. ... the db collation that control case sensitivity of object names... ...
    (microsoft.public.sqlserver.programming)
  • Re: very simple query but wrong. WHY ?
    ... > Variables case sensitivity is determined by the master db collation I ... >> I wrote a query that doesn't work at all. ...
    (microsoft.public.sqlserver)
  • Re: determine case of value
    ... Case sensitivity is determined by the ... collation which can be set at the column level or explicitly specified in ... string expressions. ...
    (microsoft.public.sqlserver.programming)
  • Re: Could not find stored procedure - But its there.
    ... Your earlier reply concluded it is a collation issue (case sensitivity is an attribute of the collation). ... Collation is an attribute of the database, and if you through backup/restore or detach/attach copy a database to some other instance, you *do not* change collation for the database. ... Are you saying that SQL Server is not case sensitive for the object names in the source server but is case sensitive on the destination server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Could not find stored procedure - But its there.
    ... not the collation of the database itself. ... But it is the db collation that control case sensitivity of object names... ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
Loading