Tim Harsch writes:
> I have this problem where I think DBD::Oracle truncated tailing whitespace
> from some input so I searched the archives and I ran accross this thread,
> where someone states that DBD::Oracle trims trailing whitespace by default.
>
> http://www.xray.mpe.mpg.de/cgi-bin/w3glimpse2html/dbi/2001-06/msg00451.html?
> 71#mfs
>
> It was the only refernce I could find but if it is true then I suspect this
> is a DBD::Sybase and DBD::Oracle inconsistency in behaviour because I don't
> think DBD::Sybase is doing it that way. I wrote a test script (below) but
> it seems to show DBD::Oracle as not trimming whitespace.
>
> Does anyone know what the expected behaviour is?
The expected behaviour depends on the database, and on the type of
char column you are sending the data to (varchar, nullable char, etc).
I don't know about Oracle, but for Sybase trailing whitespace gets
truncated for all char type columns, except "char(xx) not null".
This is not something that DBD::Sybase can control - and actually for
fixed length char columns the column will be padded with whitespace.
Your example will get truncated the same way with Sybase and
DBD::Sybase, btw.
Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
[EMAIL PROTECTED] - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
