SQL 7 Case sensetivity ?

[Slartybartfast]

I have the following question:
SQL SERVER 7
I try to update a field (data type varchar) with a string which has the same content but in a different case, the update apparently takes place but no change is made. Does SQL server check for a text comparison when an update is requested and not proceed if a match is found?

e.g 'THISTEXT' updated to 'ThisText' leaves the table still reading 'THISTEXT'.
This only seems to happen in one table of my database which is apparently no different from others.

Thanks in advance.

 

[TomSark]

This is based on how you installed SQL Server. If you installed it using case sensitivity, then case does matter. The default is to be case insenitive.

Therefore, because you apparently installed it as case insensitive, you update will be ignored. You might try to delete the row and insert the row with the new case... that'll probably do it...
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com