Hey all,
I'm working on a spectra site for a client. One of the things they would
like is to have the passwords be case sensitive, so that "passwOrd" is
different than "password". Default on a SQL Server 7.0 install, sort order
is case insensitive. Unfortunately, this client is on Oracle. So, for all
you Oracle buffs out there, a) how would I do a case sensitive search for a
password if the machine's sort order is case insensitive, and b) how can you
find out what the oracle sort order installation is?
Thanks!
AJ
PS: Here's how to do it on SQL Server. Another question I have from this
is, How much overhead do you incur by converting strings to binary or
varbinary types?
http://www.aspwatch.com/c/200034/d7C5560FD833311D4AEF600A0C9E95208.asp
It is not uncommon that you need to write a query to do case sensitive
comparison in SQL Server. The problem is, if you installed your SQL Server
using the default sort order, it is case-insensitive, in that case,
lowercase characters are paired with their corresponding uppercase
characters (for example, a and A) and are sorted before any corresponding
uppercase character with a diacritical mark (for example, �). It is
important to know that once you selected sort order, all the databases use
the same sort order, you cannot back up and restore databases between
servers configured for different sort orders, in addition, you can not
change the server�s sort order without rebuilding your Master database.
In the database with case-insensitive sort order, if you want to do the
case-sensitive comparison, such as passwords comparison, you can not use SQL
query like, SELECT * From MyTbl where column1 = �ABCD�, this query will
return the records with column1 not only equal to �ABCD�, but also �abcd�,
�AbCd� or �ABCd�, etc.
You can achieve case sensitive comparison of strings in queries by
converting strings to the binary or varbinary datatype. For example, the
following query will only return records with column1 = �ABCD� only.
Select * from MyTbl where convert(varbinary, column1) =
convert(varbinary, 'ABCD')
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
