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?
----- Original Message ----- From: "Venu" <[EMAIL PROTECTED]> To: "'David M. Peak'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 2:17 PM Subject: RE: MyODBC Question > Hi, > > > -----Original Message----- > > From: David M. Peak [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 30, 2002 12:35 PM > > To: [EMAIL PROTECTED] > > Subject: MyODBC Question > > > > > > I have a question about MyODBC and the results of > > SQLGetTypeInfo from a table with a column of type TEXT. The > > results show that the column is of type VARCHAR with a length > > of 255. Is there a way to show the true datatype? The MySQL > > that I'm running is 3.23.36. > > > That is supposed to be for the fix for invalid mapping of SET > and enum types from other vendors while migrating (MSSQL, > ACCESS, DTS and all conversion tools), else the behaviour is > not expected. > > One magic here is that, if you set this to CHAR(..) then the > Access 97 works, and if it is VARCHAR(..) then All other ACCESS > (98, 2000, XP) works, but 97 fails. We are trying to fix this > issue in next versions to have a common procedure by allowing TEXT > type to accept field size. > > 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