List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 26 2002 4:07am
Subject:Re: Which Datatype
View as plain text  
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
> 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

Thread
Which DatatypeOthmar Stehlik23 Mar
  • Re: Which Datatypedenonymous23 Mar
    • Re: Which DatatypePaul DuBois26 Mar