On 2002-02-28 11:20:48 -0700, Sterin, Ilya wrote: [with older DBI and DBD::Oracle trailing spaces on varchar2 were preserved]
> Because it was possibly fixed in the later DBD::Oracle version to function
> correctly as it is doing now.
I don't think the current behaviour[1] is correct. In perl, strings can
have trailing spaces: "test" and "test " compare as not equal.
In Oracle varchar2 can store strailing spaces: If I store 'test ' in a
varchar2 column, I get back 'test ' and not 'test' or 'test '.
Therefore I can expect that when I use perl DBI to store "test ", I
can also read back "test " and not "test". But it ain't so, and it
should be fixed.
hp
[1] DBI 1.201, DBD::Oracle 1.12.
--
_ | Peter J. Holzer | My definition of a stupid question is
|_|_) | Sysadmin WSR / LUGA | "a question that if you're embarassed to
| | | [EMAIL PROTECTED] | ask it, you stay stupid."
__/ | http://www.hjp.at/ | -- Tim Helck on dbi-users, 2001-07-30
msg09264/pgp00000.pgp
Description: PGP signature
