From: Cris Perdue
Date: July 7 1999 12:35am
Subject: MySQL "Text" fields and mm.mysql driver
List-Archive: http://lists.mysql.com/java/177
Message-Id: <3782A0C4.B0508D3B@perdues.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

The MySQL database for our site uses the "text" datatype for certain
relatively long textual data. This works fine for most purposes, but
some of our code uses metadata, or simply the "getObject" method, to
fetch data from result sets, and this does not work as desired using the

MM driver.

With the MM driver, ResultSet.getObject throws an exception ("unknown
SQL type"), and the ResultSetMetaData indicates that the SQL type is
"LONGVARBINARY", or blob.

I looked through the ListQuest mail archive, and did see a message from
Monty last year saying that there is a flag available to distinguish
"blob" data from "text" data.  In this case I presume the driver would
be able to distinguish between "blob" and "text", and getObject could
return a String for a "text" field.

Does this analysis seem correct?  And if so, is there information from
Monty (e.g. to Mark Matthews) now that would let the driver do what
looks like the Right Thing?

Thanks!
--
Cris Perdue
Impact Online, Inc.
http://www.volunteermatch.org