Hi,
Please call SQLGetTypeInfo with SQL_LONGVARCHAR, then you get the
results what is expected. Here is the output snippet:
SQLGetTypeInfo:
In: StatementHandle = 0x003A1960, DataType =
SQL_LONGVARCHAR=-1
Return: SQL_SUCCESS=0
Get Data All:
..
long varchar, -1, 16777215,
text, -1, 65535,
mediumtext, -1, 16777215,
3 rows fetched from 19 columns.
SQLGetTypeInfo:
In: StatementHandle = 0x003A1960, DataType =
SQL_LONGVARBINARY=-4
Return: SQL_SUCCESS=0
Get Data All:
..
long varbinary, -4, 16777215,
blob, -4, 65535,
longblob, -4, 2147483647,
tinyblob, -4, 255,
mediumblob, -4, 16777215
5 rows fetched from 19 columns.
Ok, also, you said you got TEXT max size as 255 in the prepares, do you
have any log on that ? Because the driver won't return the length as
255. The mapping in SQLGetTypeInfo is intended for SET and ENUM not for
direct TEXT, so it won't affect what you are describing. You can see
that the TEXT deals separatly in the same SQL_GET_TYPE_INFO_values which
returns the max length as 65535.
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <venu@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
<___/ www.mysql.com
> -----Original Message-----
> From: David M. Peak [mailto:davidpeak@stripped]
> Sent: Tuesday, April 30, 2002 2:59 PM
> To: venu@stripped; mysql@stripped
> Subject: Re: MyODBC Question
>
>
> 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
> > > >
> > > >
> > >
> >
> >
>
