Big Chuck wrote:
> 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
>
Also, is that an Oracle bug, a DBI/DBD bug, or is it merely because the
OCI changed between releases and DBI/DBD has not caught up yet?
Thanks,
Chuck
Received on Wed Jun 11 2003 - 16:02:29 CDT
