Hire a senior Perl / Python programmer today; download my up-to-date resume (PDF)
John Bokma MexIT
freelance Perl programmer

Comments: The index entry exceeds the maximum length of 900 bytes


I am working on quite a big project using Perl and MS SQL, and last Monday I ran into an issue. Because most of the week I was very busy, I decided to write down the problem and solution (or better: solutions) today.

Read the rest of The index entry exceeds the maximum length of 900 bytes.


How about shortening the URL a la tinyurl?

There's a


on CPAN.

Posted by Steven Kuo at 23:49 GMT on 13 March 2006

Steven, that module uses the TinyURL web site. Since I am storing quite a lot of URLs that's not really an option.

Also I prefer to have the URL in readable (as in understandable) format in the database.

In fact the table is a bit like TinyURL in that I map URLIDs to the longer URL value.

Posted by John Bokma at 20:23 GMT on 16 March 2006

Post a comment

Note that your comment doesn't show up immediately. I review each comment before I add it to this site.

Check the Follow this page option if you want to receive an email each time a comment is posted to this page, including yours. A link to turn this option off will be included with each email.

Internet adresses will be converted automatically. You can use the following notation to specify anchor text for a link: [url=http://example.com/]example text[/url].