Can somebody please confirm/dis-confirm this bug. If
it is indeed a bug who to contact for fix?
Platforms Affected: Confirmed on FreeBSD, Linux and
WinNT/2K with Oracle (but I assume its a DBI problem,
hence does not matter which DBD)
Example: Select * From Employee Where Name = ?
If the ? placeholder value is 'Mario ' with a space
at the end, and that value does indeed exist in the
table, it will NOT be returned.
(ps: $sth->{ChopBlanks} = 1; wont solve this problem)
Diagnosis: DBI removes trailing spaces from values
before passing them through hence the query becomes
Select * From Employee Where Name = 'Mario'
instead of the intended
Select * From Employee Where Name = 'Mario '
Thanks,
-- Amr
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
