hi, ted,
thanks for the code. i will try it.
however, up to now i've manually set the field to memo, so i don't think the
problem isn't a confusion of data types (at least not on my side -- maybe
access is confusing them for some reason).
thanks for your help.
paul
-----Original Message-----
From: Ted Stockwell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 12, 1999 4:00 PM
To: [EMAIL PROTECTED]
Subject: Re: servlets, jdbc and access
Sounds to me like you're not really using a Memo field but a Text field
instead.
Text fields are limited to 255 characters, Memo fields can hold way more.
Here's some SQL script for creating a table with a Memo field. I have used
SQL like this to create an Access database with memo fields that I've then
redeployed on other DB's (though not Sybase).
CREATE TABLE anytime_course (
id INT
,
name VARCHAR(64),
overview_memo LONGCHAR
)
ted stockwell
> -----Original Message-----
> From: Paul Szynol [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 12, 1999 10: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?
>
>
___________________________________________________________________________
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
