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" <venu@stripped>
To: "'David M. Peak'" <davidpeak@stripped>; <mysql@stripped>
Sent: Tuesday, April 30, 2002 2:17 PM
Subject: RE: MyODBC Question
> 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
>
>
>
