MySQL TEXT Column Type displayed as CLOB

[Nobody/Anonymous]

I'm a new user to iSQL-Viewer. Installation and connection to a MySQL database was straight forward. I do have one problem I can't seem to solve. When I execute a SQL query the ResultSet displays the column fields as "CLOB" and then the length in bytes. The MySQL column type is TEXT. I'm using the org.gjt.mm.mysql.Driver in mysql-connector-java-3.1.7. I've used the same database and driver in other SQL clients and the result sets are seen as text. What bit of knowledge am I missing for iSQL-Viewer?

Thanks!

[Markus A. Kobold]

TEXT type translates to CLOB with the implementations of  MySQL JDBC; so if you want to see the actual content you would have to right click on the field and view them as text seperately.

Other applications might just imply CLOB data to string
however my reasons for not doing are merely from an efficency standpoint of not loading more data than is required and thus creating an unpleasent user expierence when no more memory is available.

If the column in question isn't holding that much text you may want to change the type to a CHAR or VARCHAR