I'm accessing a SQL Server 7.0 database with the Win32::ODBC module.

I have a table with 5 columns defined as datatype = varchar and length =
2000.

Using the following syntax in my perl scripts, $db->Sql("INSERT ......."),
all
works well. Data up to and including 2000 characters can be inserted without
error. This is confirmed by looking at the tables interactively using the
SQL
Server interface.

However, by using the following in my perl scripts,

   $db->Sql("SELECT .....");
   $db->FetchRow();

only the first 256 characters of data for each column are returned.

What is strange is that the previous database that I was using was Access,
and
I was able to return the entire entry (all 2000+ characters) using the above
syntax. It was only after switching to a SQL Server 7.0 database that this
unusual behavior was shown.

I tried tinkering with the SetMaxBuffSize function (ODBC.pm) with values
up to 100000k (the default is 10240k), but to no avail.

Any thoughts or guidance would be much appreciated.