I've seen this discussion go on, and thought I must be missing
something. I guess I still am, but I don't understand why you don't just do
what you yourself suggested initially:
> Is their a way to use one text area on my JSP and two varchar fields
> to insert the data into.
In the database, create four varchar fields, size 250 each. When the
1000 character data comes in, use substring() or however to break it into
four strings of 250 each. If you're really concerned about empty space, you
could even create a subtable that has one 250 char column of the text per
row. Anyhow, load and update the four columns.
On the retrieval, either use SQL or Java to concatenate the four
character columns into one to load the textarea.
This seems very straightforward to me, so I will be happy to know that
I've overlooked something. HTH,
Joe Sam
Joe Sam Shirah www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Qué Java400? http://www.jguru.com/faq/Java400
----- Original Message -----
From: "Tom Kochanowicz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 23, 2002 7:26 PM
Subject: Re: Text Area & Limit ed datbase fields.
> The data will be used to store information on pets (dogs, cats etc). The
max
> number of characters is to be 1000. Their will be as many as 10000 records
> and searches will be performed using either a key field e.g. customer
number
> or using a %LIKE% sql command. So it is simply a store and retrival type
of
> operation. Perhaps I need to look at a database that supports varchar of
> 1000 characters rather then mySQL. We are running Linux so this will go
> beyond our low budget. Thanks for the reponces.
>
> TK
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Will
> Hartung
> Sent: Monday, December 23, 2002 11:16 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Text Area & Limit ed datbase fields.
>
>
> > I am using a JSP/Servlet to capture data to be inserted into an
> mySQL
> > database. The database has a maximum limit on varchar of 255 charaters.
I
> > need to have double that amount. I could use MEDIUM_BLOB but that is way
> too
> > big. Is their a way to use one text area on my JSP and two varchar
fields
> to
> > insert the data into. I heard of other databases with this restriction.
> What
> > is the most effective way to handle this problem?
>
> How is the data going to be used? What kind of operations are going to be
> performed on it? How many rows of data do you plan on storing?
>
> All of these can affect the final solution that you choose.
>
> Regards,
>
> Will Hartung
> ([EMAIL PROTECTED])
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
