Long (403 character) URLs stored in hyperlinks?

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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Siegfried Heintze" wrote in message
...
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