Bill Rawlinson said the following on 2/14/2006 10:20 PM: > sort of - somehow my encrypted string is losing its trailing space. > However, buskirj encrypted comes out with a trailing 0 and a space > but if you decrypt either the encrypted buskirk without the trailing > space OR the encrypted buskirj they both return buskirj > > it is the only string I am having this problem with. I can't find a > single reason for losing the trailing space in the encrypted buskirk > but it is causing a user with that last name untold grief. > > Bill I would say you aren't the only one who had this problem: http://www.experts-exchange.com/Databases/Mysql/Q_21712091.html
I'm unfamiliar with Oracle, are you sure you are escaping all characters when you persist the string in the db? Are you using cfqueryparam when persisting the encrypted pwd? I'd really suggest you move to SHA, AES or even MD5 to store password -- using these one-way hash alogs. Most hash alogs should already be built into your DB product (although IIRC, MSSql 2000 doesn't have any). .Peter -- Peter J. Farrell :: Maestro Publishing Member Team Mach-II :: Member Team Fusion http://blog.maestropublishing.com Create boilerplate beans and transfer objects for ColdFusion! Fire up a cup of Rooibos! http://rooibos.maestropublishing.com/ ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org
