SQL Server Case Sensitivity

J

JimP

I'm working with (2) SQL Server db's, both with case sensitivity enabled .

In one case, I have a query that links a local table, with lower case codes,
to a SQL Server table with upper case codes - All matching records are
retrieved (case sensitivity apparantly is NOT enforced)

In the other case, the query does not retrieve any records (case sensitivity
apparantly is enforced).

I would like to NOT enforce case sensitivity, and am at a loss to figure out
why it is not enforced in the first case and is in the second.
 
R

Robert Morley

I'm no expert, so I can't really help beyond this suggestion, but I believe
you can enforce rules like this at the field level in SQL Server. Perhaps
you should poke around the various field properties and see if something is
defined.


Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Case Sensitivity in SQL Server db 1
Combo Box case sensitivity 0
key sensitivity 1
Case sensitivity 6
how do I deal with case sensitive data in Access? 2
Case sensitivity & Primary key 5
Lower-Case Characters 2
Need a Case-Sensitive Group By Totals Query - Is there a Workaroun 5

Top