to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 24 January 2001 13:03
To: CF-Talk
Subject: RE: case sensitivity in stored procedures
It can be done! You can byp
4, 2001 12:55 PM
>To: CF-Talk
>Subject: RE: case sensitivity in stored procedures
>
>
>
>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
o:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 8:03 AM
To: CF-Talk
Subject: RE: case sensitivity in stored procedures
It can be done! You can bypass the case-insensitivity, although it's a bit
long winded (but it works).
What you need to do is use the ASCII character number to ma
There's another reason you don't want case-sensitivity turned on for the whole
server... the Merant database drivers have a bug in them: they have internal calls to
a stored procedure named sp_SeRvEr_InFo when the actual stored procedure is named
sp_server_info. With case sensitivity turned on
; To: CF-Talk
> Subject: RE: case sensitivity in stored procedures
>
>
>
> 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 gi
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
0.htm
Nick
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 4:01 AM
To: CF-Talk
Subject: Re: case sensitivity in stored procedures
can you give me a hint?
Sebastian
on 1/23/01 11:34 AM, DeVoil, Nick at [EMAIL PROTECTED] wrote:
&
can you give me a hint?
Sebastian
on 1/23/01 11:34 AM, DeVoil, Nick at [EMAIL PROTECTED] wrote:
>> Can you do a case sensitivity comparison within a SQL Server stored
> procedure?
>
> Yes.
>
>
> **
> Information in this em
I would certainly also like to see if people have easy ways of doing this
(short of evaluating each character using CHR).
If one allows two different users with passwords 'sEcreT' and 'SecrEt', for
example, how to distinguish these?
Mark
[EMAIL PROTECTED]
> Can you do a case sensitivity compar
Yes, check out the SQL faq
http://www.swynk.com/faq/sql/sqlserverfaq.asp
Justin
>-Original Message-
>From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 23, 2001 5:34 PM
>To: CF-Talk
>Subject: RE: case sensitivity in stored procedures
>
>
> Can you do a case sensitivity comparison within a SQL Server stored
procedure?
Yes.
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
11 matches
Mail list logo
