SEO

#1 (**permalink**) 04-24-2008, 06:08 PM

I'm working with MS-Access and (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.

Is there a property somewhere that I can set?

#2 (**permalink**) 04-29-2008, 08:26 PM

Maybe the Option Compare Database/Text/Binary ?

http://support.microsoft.com/kb/98227/en-us/

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

"JimP" <jpockmire@pockmiresolutions.com> wrote in message
news:2uWdnQmEk9TqH43VnZ2dnUVZ_qiinZ2d@comcast.com. ..
> I'm working with MS-Access and (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.
>
> Is there a property somewhere that I can set?
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL Server Case Sensitivity