At 15:47 -0500 3/23/02, denonymous wrote:
>From: "Othmar Stehlik" <o.stehlik@stripped>
>> I´m writing a simple Guestbook in Java, but I´m not quite sure which
>> Datatype I should use for the user´s comments.
>> VARCHAR is not big enough,
>Try TEXT or TINYTEXT.
TINYTEXT is no longer than VARCHAR(255). One of the larger TEXT types
would be better.
>However, you may want to have a check in place before it goes into the
>database to trim it down to a reasonable size in the event some joker
>decides to paste a few thousand lines of text into the comments.
Or pasting in a core dump image, to see if your script is capable of handling
input with unusual characters.
Yes, it happens.