On Tue, Mar 11, 2003 at 09:28:50PM -0500, Matthew O. Persico wrote:
> --- Original Message ---
> From: "M. Addlework" <[EMAIL PROTECTED]>
> To: Matthew O. Persico <[EMAIL PROTECTED]>
> Cc:
> Sent: Tue, 11 Mar 2003 15:59:27 -0800 (PST)
> Subject: Re: Fwd: C
On Tue, 11 Mar 2003 18:09:44 -0500 "Matthew O. Persico" <[EMAIL PROTECTED]> wrote:
> On Mon, 10 Mar 2003 20:44:26 -0800 (PST), Michael A Chase wrote:
> >http://xmlproj.com/fom-serve/cache/124.html
>
> That's what I thought should happen. And I really don't have
> a problem with that happening.
--- Original Message ---
From: "M. Addlework" <[EMAIL PROTECTED]>
To: Matthew O. Persico <[EMAIL PROTECTED]>
Cc:
Sent: Tue, 11 Mar 2003 15:59:27 -0800 (PST)
Subject: Re: Fwd: Cannot bind a single blank space to a non-null varchar?
>
>>Why isn't the trailing whi
On Mon, 10 Mar 2003 20:44:26 -0800 (PST), Michael A Chase wrote:
>On Mon, 10 Mar 2003 22:55:26 -0500 "Matthew O. Persico"
><[EMAIL PROTECTED]> wrote:
>
>>Conclusion: somewhere in bind_param or whatever it is that it
>>invokes, trailing blanks are being stripped before the call to the
>>OCI.
>>
>>I
On Mon, Mar 10, 2003 at 10:55:26PM -0500, Matthew O. Persico wrote:
> I am calling bind_param like this:
>
> $sth->bind_param($col_idx,
> $value,
> {TYPE =>?DBI::SQL_VARCHAR});
>
> for a co
On Mon, 10 Mar 2003 22:55:26 -0500 "Matthew O. Persico" <[EMAIL PROTECTED]> wrote:
> Conclusion: somewhere in bind_param or whatever it is that it
> invokes, trailing blanks are being stripped before the call to the OCI.
>
> I was able to get around this by using
>
> $sth->bind_param($col_idx,
>
I am calling bind_param like this:
$sth->bind_param($col_idx,
$value,
{TYPE => DBI::SQL_VARCHAR});
for a column defined as varchar(8), not null
When $value == ' ' (one space) or $valu
