Is it possible that you're doing a GET, rather that a POST, on the HTML
form in
which you solicit the content of the memo field? If so, truncation
might actually be
due to the limitation on URL length, and have nothing to do with JDBC
and/or Access?
// Michael Winterbottom
> -----Original Message-----
> From: Paul Szynol [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 12, 1999 9:48 AM
> To: [EMAIL PROTECTED]
> Subject: servlets, jdbc and access
>
> hey, everyone,
>
> im writing servlets that connect to a database, as i guess many of us
> are.
> for the moment, i'm using access, though eventually i will switch over
> to
> sybase. so, the basic process is to retrieve the information
> submitted from
> an html form, and then submit the java string to access via jdbc.
> all's
> well, basically, but i've found that access truncates the memo field
> at 255
> characters -- the memo field is supposed to hold up to 64K, i believe.
> it
> does this no matter what i enter into the field. moreover, i've tried
> this
> with access 97 and access 2000, and the same thing happens.
>
> i am curious --
>
> 1. does anyone know a way around this problem?
> 2. does anyone know if sybase does something similar?
>
> thanks very much.
>
> best,
> paul
>
> ______________________________________________________________________
> _____
> 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
