Venu:
Thank you so much. That fixed my problem.
----- Original Message -----
From: "Venu" <venu@stripped>
To: "'David M. Peak'" <davidpeak@stripped>
Sent: Tuesday, April 30, 2002 4:06 PM
Subject: RE: MyODBC Question
> Hi,
>
> Please check the option 'Allow big results' from DSN or OPTION=8
> enabled, then it will return the length to handle big packets.
>
> 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 4:01 PM
> > To: venu@stripped
> > Subject: Re: MyODBC Question
> >
> >
> > thank you for the info. As for the last part of the
> > statment, I meant to say that the function SQLDescribeParam
> > returns 255 as the length of the TEXT column. Is there a way
> > around that?
> >
> >
> > ----- Original Message -----
> > From: "Venu" <venu@stripped>
> > To: "'David M. Peak'" <davidpeak@stripped>;
> > <mysql@stripped>
> > Sent: Tuesday, April 30, 2002 3:30 PM
> > Subject: RE: MyODBC Question
> >
> >
> > > 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
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <mysql-thread107669@stripped>
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-davidpeak=softhome.net@stripped>
> > > Trouble unsubscribing? Try:
> > http://lists.mysql.com/php/unsubscribe.php
> > >
> >
>
>
