On Wed, 23 Jul 2003 07:53:50 -0700 Fuller Mark-acus10 <[EMAIL PROTECTED]> wrote:
> When I "fetchrow_array," a column that contains one space (' ') is
> returned to me as an undef. Is this the correct behavior?
>
> I am positive the column is one space. I have selected it using SQLPlus.
> "where x is null" or "where x eq ''" returns nothing. "where x eq ' '"
> returns the row. But, in Perl the fetchrow_array gives me an undef for
> that column.
>
> I'm using Oracle 8.1.7. Perl 5.6.1. DBI 1.03. Oracle DBD 1.07.
DBD::Oracle returns string data as VARCHAR which strips trailing
whitespace and treats the resulting empty string as NULL.
--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
