I don't mean to beat a dead horse here, but when the backend checks the
length of the datatype for the columns to prepare the statment, the TEXT
column comes back as length of 255 so my 1,500 char string gets cut off. Is
there a datatype that the MyODBC driver will return as character data
greater than 255?
----- Original Message -----
From: "Venu" <venu@stripped>
To: "'David M. Peak'" <davidpeak@stripped>; <mysql@stripped>
Sent: Tuesday, April 30, 2002 2:45 PM
Subject: RE: MyODBC Question
> Hi,
>
> > -----Original Message-----
> > From: David M. Peak [mailto:davidpeak@stripped]
> > Sent: Tuesday, April 30, 2002 2:44 PM
> > To: venu@stripped; mysql@stripped
> > Subject: Re: MyODBC Question
> >
> >
> > So what is the best way to store information in a MySQL
> > database through MyODBC that is of a character type that is
> > greater that 255 chars? BLOB?
>
> You can always make use of TEXT, MEDIUM TEXT,
> LONG VARCHAR, .. and similarly for BLOBs.
>
> Regards, Venu
> --
> For technical support contracts, go to https://order.mysql.com
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Venu <venu@stripped>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
> /_/ /_/\_, /___/\___\_\___/ California, USA
> <___/ www.mysql.com
> > >
> > >
> >
>
>
