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
