[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Question on BOOLEAN data type,

My question is related to Mckoi BOOLEAN data type. I have a column in my
table whose SQL data type is BOOLEAN. 

stat.executeUpdate("CREATE TABLE Test_table ("Name VARCHAR(16) , status
BOOLEAN NOT NULL)");

When i query the columnType (getColumnType(2)) it reports is as
"java.sql.Types.BOOLEAN" which is correct.


But when i view my table in DbVisualizer the JDBC Mapping for the SQL type
says "UNKNOWN".

******************************************************************
Column Name     Type(Database)	Type (JDBC)	Type (Java)
    Name           VARCHAR	 VARCHAR     java.lang.String
   Status          BOOLEAN	 UNKNOWN     java.lang.Boolean
******************************************************************

Can i get some pointers on this.
thanks
vinodh