Hi,
> -----Original Message-----
> From: David M. Peak [mailto:davidpeak@stripped]
> Sent: Tuesday, April 30, 2002 12:35 PM
> To: mysql@stripped
> 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 <venu@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
<___/ www.mysql.com
