I just found the following in an archive (I believe of this list) and it
sounds like my problem exactly (not sure of byte length, but is definitely
size oriented)! Is this still a problem, the message below was dated Tue, 10
Feb 1998.
> From: Ken Whiting <[EMAIL PROTECTED]>
>
> Tim, I posted a message about this to the list a few weeks back, but I
> didn't get any worthwhile response.
>
> I'm having a problem with DBD::ODBC (on NT) and inserting longs into
> MSSQL server. Same setup, switch the DSN to an Oracle driver, and it
> works perfectly. In MSSQL, if I go over 256 bytes, I get a '22001 -
> String data right truncation' error. I've set the LongTruncOk and
> LongReadLen to no avail, and as I said Oracle through ODBC works
> perfectly.
Sounds like an ODBC driver bug not a DBD::ODBC problem.
The DBD::ODBC is rather Alpha and I'll be looking into longs etc
before the next release.
Tim.
p.s. As the README says, please don't mail me directly. Use the list.
Thanks.
______________________________________
splehP ttocS
rotartsinimdA smetsyS TN
secivreS tenretnI renroKbeW
moc.renrokbew@pttocs
moc.renrokbew.www
$a="@ARGV";while($a){$a=~s/(.$)//;$b=$b.$1;}print "$b\n";
______________________________________
