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

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)