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 <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > -----Original Message----- > From: David M. Peak [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 2:59 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > To: "'David M. Peak'" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, April 30, 2002 2:45 PM > Subject: RE: MyODBC Question > > > > Hi, > > > > > -----Original Message----- > > > From: David M. Peak [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 30, 2002 2:44 PM > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > > 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 <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
