Well do you want the default to go back to CHAR? Not sure what you mean by fix it.
Ilya -----Original Message----- From: Jeff Hunter To: Peter J. Holzer Cc: '[EMAIL PROTECTED] ' Sent: 2/28/02 2:13 PM Subject: Re: Whitespace being truncated with Oracle I agree, it should be fixed. Peter J. Holzer wrote: >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. >
