This a nice one!
Has anyone ever deployed a SQL2000 or SQL7 database using a Hungarian collation(Hungarian_CI_AS)?
I've encountered some very strange behaviour in T-SQL statements, more specifically in stored procedures. It appears that (I swear, i'm not joking) every variable, table name or field name used in a sp containing the word 'year' (eg:FinancialYear, YearOfBirth...) suddenly becomes case sensitive?! If you, for instance write the following :
DECLARE @FinancialYear SMALLINT
SELECT @Financialyear = FinancialYear FROM Table1 --notice the spelling of the variable
Using the Hungarian collation Hungarian_CI_AS
this will fail reporting error : Must declare the variable '@Financialyear'.
The strange thing is that, all other variables, not containing the word 'year', appear not to have this problem, you can mix case however you want... no problem.
I have never heard of T-SQL being case sensitive.
I'm guessing that this is a bug.
Has anyone ever encountered such behaviour ?