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 thi
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 wh
Roland Lammel [mailto:[EMAIL 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->prepa
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 = 'Ma
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:
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 '
Yo
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 ? p