Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

perl-programmer-john (6492)

perl-programmer-john
  (email not shown publicly)
http://johnbokma.com/

Started to use Perl somewhere around 1993, and since then have been using it in-house and in several projects for customers. I am available as a freelance Perl programmer.
Monday March 13, 2006
02:54 AM

The index entry exceeds the maximum length of 900 bytes

[ #28974 ]

Ok, this sounds like an MS SQL issue, which is right. In itself it's interesting, since I use Perl to "talk" with MS SQL, and I wrote some Perl snippets to show you how: The index entry exceeds the maximum length of 900 bytes

What makes it more interesting is that while writing the entry I found a fix for the "Invalid character value for cast specification (SQL-22018)" error I got in an earlier attempt, by explicitly setting the column type using the DBI bind_param method. One day it might bite you, and hopefully you'll remember the solution.