I'm having some anoying problems with a small script which accesses a database.
I'm connecting to an MS SQL server through an ODBC connection using DBI and DBD:ODBC... this works fine until i attempt to fetch text data with more than 80 chars. It will also work at 81 chars, but will then only return the first 80 chars.. anything more than that and it just returns a blank field.
Is this a known bug? or some sort of setting that can be made?
Any help or pointers to documents that might contain help will be greatly apreciated. btw. the code is running on an NT server with IIS 4.0 and MS SQL 7.0. The perl distribution is from activestate.