Re: SQL safe input?

On Sat, Aug 27, 2005 at 18:55:54 -0700,
operationsengineer1(at)yahoo(dot)com wrote:
> --- Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
>
>
> Can you give us an idea of what a "really long string
> is?" is it something i need to worry about in varchar
> field where notes are entered?
>
> if someone enters a string note like:
>
> "test unit failed; os2; likely failure; where t=2"
>
> will it fail b/c of the ";"s?

That wouldn't be a problem. If someone entered one that was gigabytes in
size it may be a problem in terms of flushing your memory of useful things
and slow performance down. If there is a bug, a few kilobytes could cause
a problem. If you know the data can't be more than a few 10s of bytes
you probably want to not process ones much larger as it is probably
someone trying to mess with you.