The Plankmeister,
Jet databases define text colums as a max length of 255 characters.
Everything after that is ignored. Memo is not a text datatype but an
embedded object capable of storing 64,000 characters. You are running into
the limits of the length of a text column in a Jet database. If possible,
try using MSDE or some other data engine that supports wider text columns.
"The Plankmeister" <plankmeister_NOSPAM_@hotmail.com> wrote in message
news:404a5eae$0$27438$edfadb0f@dread16.news.tele.d k...[color=blue]
> Hi...
>
> If I run one of my queries which prompts for input of type memo, and I[/color]
paste[color=blue]
> a chunk of text into the box, it doesn't matter how big the text is, if[/color]
it's[color=blue]
> more than 206 characters, it truncates the string. It also does the same
> thing if I try to run the query as a stored procedure through PHP, though[/color]
in[color=blue]
> this case it allows 283 characters.
> If I run the query as a normal update query using PHP, I can update
> thousands of characters.
>
> Anyone know what's going on?
>
> It's Access 2002 with the latest Jet service pack.
>
> Plankmeister.
>
> --
>
>
>[/color]
