Jon, I wholeheartedly agree that a password should be a case sensitive check, without a doubt. My apps always do that. But that kind of illustrates my point: *my apps handle it*. I believe that case rules should fall on the shoulders of the app, not the database. I have no problem whatsoever with there being a case sensitive datatype, or an option on the field/column to make it case sensitive... hell, I'd fully support that. But to just blanketly make data case sensitive? (Sorry, I'm still in a state of shock. :-) )
For instance, take a search form. I think it's insane to expect people to use the same case in their search string as was entered into the database. I was really hoping there was a way around that behavior, without modifying all of my queries. Oh well, I guess either A) I'll have to continue to bite the MS SQL $$$ bullet, or B) I'll have to write a second set of files that are set to handle the case-sensitive nature of Pg. Thanks for the help! Matt On 1/13/07, Jon Clausen <[EMAIL PROTECTED]> wrote: > > Matt, > > There's no way that I know of. Just my 2 cents, but I think that > case sensitivity with data is a wonderful thing - especially when it > comes to user authentication. (http://en.wikipedia.org/wiki/ > Password_strength) > > I think you'll probably have to handle that within the query - or > just change the username and password to lowercase. > > Jon > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
