Problem turning on "Dont Optimize Column Width"

------_=_NextPart_001_01C5EA1C.399464DC
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

=20

I am connecting to MySql via the Java JDBC-ODBC bridge and the MySql
ODBC Connector. (Yes, I know it is not recommended for production use.
For production, we use the MySql JDBC Connector, but for various
reasons, it is easier for development to use the bridge.)

=20

I am seeing strange behavior regarding the "Don't Optimize Column Width"
parameter of the ODBC Connector. When I have this option turned off, I
can query longtext fields in my SELECT statement without a problem.
However, when it is turned on, longtext field values are returned as
null. What is strange about this condition is that I have seen many
postings suggesting just the opposite - if your client is having
problems reading data, turning on this flag will often solve the
problem. Does anyone know why turning off this flag in this case works,
but turning it on does not? =20

=20

We are using MySql ODBC Connector 3.5.12, but get the same behavior with
earlier versions as well.

=20

Thank you,

Gary Hirschhorn

Fetch Technologies

=20

=20

=20


------_=_NextPart_001_01C5EA1C.399464DC--