2 messages in com.mysql.lists.javaDatabaseMetaData.getTypeInfo() vs get...
FromSent OnAttachments
Luca Lafranchi24 Jan 2003 05:37 
Mark Matthews24 Jan 2003 09:50 
Subject:DatabaseMetaData.getTypeInfo() vs getColumns()
From:Luca Lafranchi (luca@rohag.ch)
Date:01/24/2003 05:37:59 AM
List:com.mysql.lists.java

Hi :)

I'm playing a little with java.sql.DatabaseMetaData, and I encountered following: if I call DatabaseMetaData.getTypeInfo(), the "mediumtext" type is given a precision of 16777215, which is correct; if I call DatabaseMetaData.getColumns(...), the precision of any "mediumtext" columns is only 65535 (->"text"). The same happens for "mediumblob" and "blob". I've not checked for the others ("long-","tiny-").

Ciao Luca