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