Re: Building DBD::Oracle on Solaris and 9i 64-bit

From: Big Chuck <ccarson_at_echeeba.com>
Date: Wed, 11 Jun 2003 13:55:44 -0700
Message-ID: <3EE79750.6020504@echeeba.com>

Andy Hassall wrote:
> On Wed, 11 Jun 2003 13:01:48 -0700, Big Chuck <ccarson_at_echeeba.com> wrote:
>
>

>>Thanks a bunch, that worked great. However a few tests did fail. Do I
>>need to be worried about these:
>>
>>t/ph_type....ok 11/19 expected 'trailing' but got 'trailing ' for
>>VARCHAR2
>>t/ph_type....FAILED test 12

>
>
> And that's another issue that's been discussed on the mailing list :-)
>
> It appears that Oracle have changed the behaviour regarding stripping of
> trailing spaces from VARCHAR2 bind variables in 9.2's OCI - I don't think
> there was absolute agreement on this issue yet, but there are some Oracle
> bugs on listed on Metalink relating to similar issues.
>
> You may want to watch out if you do have trailing spaces in your VARCHAR2
> fields, but generally it doesn't seem to much of a problem, particularly
> since the new behaviour seems to be to preserve them rather than discard
> them.
>
> --
> Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
> Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

You mean trailing white space in the actual row data? ie: If I inserted "smith " into a varchar2 field?

-Chuck Received on Wed Jun 11 2003 - 15:55:44 CDT