At 15:47 -0500 3/23/02, denonymous wrote: >From: "Othmar Stehlik" <[EMAIL PROTECTED]> > >> I´m writing a simple Guestbook in Java, but I´m not quite sure which SQL >> 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. > > > >-- >denonymous >www.coldcircuit.net --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php