1 message in com.mysql.lists.javaDatabaseMetaData.getTypeInfo() vs. ge...
FromSent OnAttachments
Luca Lafranchi24 Jan 2003 06:34 
Subject:DatabaseMetaData.getTypeInfo() vs. getColumns()
From:Luca Lafranchi (luca@rohag.ch)
Date:01/24/2003 06:34:29 AM
List:com.mysql.lists.java

Hi :)

I'm playing a little with java.sql.DatabaseMetaData and mysql 4.0.9-gamma, 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