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 ?
On Tue, 2 Apr 2002 23:16:47 -0800 (PST), Amr Awadallah wrote:
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 '
You're
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does not work:
$sth-prepare('Select * From Employee Where Name =
?');
and then you $sth-execute('Mario ');
(no offense to Mario of course)
-- Amr
--- Bart Lateur [EMAIL PROTECTED] wrote:
On Tue, 2 Apr 2002 23:16:47
Does it work when using single quotes around the placeholder?
Instead of
$sth-prepare('Select * From Employee Where Name = ?');
try
$sth-prepare(Select * From Employee Where Name = '?');
Cheers
+rl
Amr Awadallah wrote:
yes, this works:
Select * From Employee Where Name = 'Mario '
PROTECTED]]
Sent: 03 April 2002 11:11
To: Amr Awadallah
Cc: Bart Lateur; [EMAIL PROTECTED]
Subject: Re: BUG: Perl DBI truncates Trailing Spaces from Placeholder
Bind Variables.
Does it work when using single quotes around the placeholder?
Instead of
$sth-prepare('Select * From Employee Where Name
On 2002-04-03 02:06:15 -0800, Amr Awadallah wrote:
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does not work:
$sth-prepare('Select * From Employee Where Name =
?');
This is a known behaviour of DBD::Oracle. There are several low-level
Oracle types which perl
Bind it as CHAR.
Ilya
-Original Message-
From: Amr Awadallah
To: Bart Lateur; [EMAIL PROTECTED]
Sent: 4/3/02 3:06 AM
Subject: Re: BUG: Perl DBI truncates Trailing Spaces from Placeholder Bind
Variables.
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does