in reply to DBI: $sth->{NAME}

Is Sybase trimming the column name? Have you tested trying something like: 

create table foo (
   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXA integer,
   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXB integer
);

[download]
If that generates an error, DBI (or the DBD driver) is probably doing the right thing.

Replies are listed 'Best First'.
Re: Re: DBI: $sth->{NAME}
by crouchingpenguin (Priest) on Sep 12, 2002 at 20:44 UTC
    No, sybase isn't trimming the column name. sp_columns ${table_name} returns the full name of the column.
[reply]

      Since Sybase was trimming the columns, I guess you won't trust that method anymore! (You didn't try my example either, did you? ;)

[reply]

In Section Seekers of Perl Wisdom