Long (403 character) URLs stored in hyperlinks?

[Siegfried Heintze]

I'm using perl to store urls in fields of type hyperlink. It seems that it
truncates them to 255 characters. Is this a problem with the perl DBI or MS
Access? I've tried using text, memo and OLE object (I cannot remember what
those are called -- something like OLE Object) and none of them allow me to
store more than 255 characters. The latter type seems to corrupt my string
too (although the documenation warned me about that possibility). I get an
"[]" append on to the end of my url when I use "OLE Object" to store my url.

Any perl programmers know of a workaround?

Sieg

 

[Douglas J. Steele]

Memo fields can certainly store 403 character strings without any problems,
so I suspect that the problem's either with the perl DBI or with your code.