Re: Are SQL logins case sensitive
From: Uri Dimant (urid_at_iscar.co.il)
Date: 01/28/04
- Next message: Johnson Ng: "SQL Server Authentication"
- Previous message: Tibor Karaszi: "Re: Are SQL logins case sensitive"
- In reply to: Don Grover: "Re: Are SQL logins case sensitive"
- Next in thread: Wayne Snyder: "Re: Are SQL logins case sensitive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 28 Jan 2004 11:04:35 +0200
Don
Look at below examle helo to solve the problem
create table ABCD
(
[password] varchar(20) null
)
insert into ABCD([password])values ('ABCD')
DECLARE @p VARCHAR(100)
SET @p='AbcD'
SELECT [password] FROM ABCD
where charindex(cast(@p as varbinary(20)),cast([password] as
varbinary(20)))> 0
SELECT [password]
FROM ABCD
WHERE [password] =@p COLLATE Latin1_General_BIN
SELECT [password]
FROM ABCD
WHERE charindex(@p,[password] COLLATE Latin1_General_BIN)>0
drop table ABCD
"Don Grover" <spamfree@assoft.com.au> wrote in message
news:ujdZn7U5DHA.2764@TK2MSFTNGP09.phx.gbl...
> I tried BOL, but it does not specify case sensitive.?
> Im also wondering what characters can only be entered by the keyboard
etc,.
> and not through a sp or the like.
>
> Don
>
> "Satish Balusa" <sbalusa_nospam@corillian.com> wrote in message
> news:uwThpdT5DHA.1632@TK2MSFTNGP12.phx.gbl...
> > It depends upon the Collation you are using.
> > If you are using Dictionary Order Case Insensitive, which is the
default,
> I
> > guess it should not make a difference.
> >
> > --
> > HTH
> > Satish Balusa
> > Corillian Corp.
> >
> >
> > "Don Grover" <spamfree@assoft.com.au> wrote in message
> > news:e7fFlXT5DHA.2404@TK2MSFTNGP12.phx.gbl...
> > > SQL2k
> > > Are user passwords case sensitive, ie Ab234 <> ab234
> > > If not can I make this happen?.
> > >
> > > Don
> > >
> > >
> >
> >
>
>
- Next message: Johnson Ng: "SQL Server Authentication"
- Previous message: Tibor Karaszi: "Re: Are SQL logins case sensitive"
- In reply to: Don Grover: "Re: Are SQL logins case sensitive"
- Next in thread: Wayne Snyder: "Re: Are SQL logins case sensitive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
