Nick, this was helpful, thanks - I didn't realize it was an installation
option, and I've never seen it installed except with the default setting. I
looked it up in BOL and it gives pretty good details. I'm sure I've been
lazy enough with object names, etc. that I wouldn't want case-sensitivity
ON - half my queries or code might fail. Well maybe not half, but some.
I had been trying out some code with tests of exact (case-sensitive) words,
such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems
that the case-sensitivity setting relates to this too. As a result, SEcret,
seCRET, SeCrEt, etc. all come up as LIKE the above expression.
So it might be better to say that SQL Server is case-insensitive by
default, period.
Mark
[EMAIL PROTECTED]
Sebastian
Apologies, not a very helpful answer.
What I meant was SQL Server is case-sensitive, period.
But actually that's not always true, only if SQL Server is
installed with a case sensitive sort order.
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/8_ar_da_
10.htm
Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
