Comment Feed for SQL Case sensitivity (TechOff on Channel 9)

Re: Re: Re: SQL Case sensitivity

PerfectPhase — Fri, 03 Oct 2008 13:12:51 GMT

Good call, it would appear I've built the database with a CS collation rather than CI. Next rebuild I reset it and see what happens.

Re: Re: SQL Case sensitivity

cheong — Fri, 03 Oct 2008 01:57:47 GMT

Setting to collation to "CS"s instead of "CI"s of database will definately affect your case, but I doubt that'll affect how the server interprete the SQL statements as well.

But maybe PerfectPhase can try to set the server collation to those one of those "CI" types...

Re: SQL Case sensitivity

Matthew van Eerde — Thu, 02 Oct 2008 21:40:30 GMT

I believe this can be specified per-database; it also controls whether 'a' == 'A', for example.

Re: Re: Re: SQL Case sensitivity

W3bbo — Thu, 02 Oct 2008 18:35:10 GMT

Minor pedant's complaint.

But in the context of security, it's spelled "Principal" not "Principle" :)

Re: Re: SQL Case sensitivity

PerfectPhase — Thu, 02 Oct 2008 17:31:35 GMT

Not sure what's happened here, suddenly started getting runtime errors about tables and fields not existing, for example...

BAD:

GOOD:

Think it must be something to do with how the database project is deployed, just moved from DBPro GDR CTP16 to CTP17.

Re: SQL Case sensitivity

Sven Groot — Thu, 02 Oct 2008 16:57:46 GMT

Never? It's definitely not on my SQL Server 2008 boxes.