oracle is case sensitive "Aaron Johnson" <[EMAIL PROTECTED]> wrote: 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?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 ------------------------------------------------------------------------------------------------ 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]
