Case Sensitivity in T-SQL and CLR

Peter W. Debetta blogs about what can happen when mixing T-SQL with a case insensitive coallation sequence vs. code and data created using a CLR language such as T-SQL.

This is an interesting issue. The idea of anything in T-SQL being case sensitive is not anything I had thought about, but of course when calling a C# object, it makes complete sense that it is case sensitive.

I have not tested, but I wonder if in a case insensitive language such as VB.NET, whether you have to enter the property/method name with the same exact casing as in the VB.NET code?

Posted by Douglas Reilly at 05:21 PM  Permalink