what type should I use ? long Binary ??

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

I want to use MySQL as my Database.But I come across a problem. MySQL have some data types like

Code:

"long text , long binary , long blob,smallint "

I know data type varchar is java String only. What java data type should I use according MySQL? For example : What is long binary in Java ? Is it Blob? Thks

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Any idea? : (

steve · **Posted:** Mon May 24, 2004 1:37 pm

It depends upon the JDBC types that MySQL maps those DB type to. To check this, obtain a jdbc connection and do the following connection.getMetaData().getTypeInfo() This will return you a ResultSet where each row describes a SQL type in the underlying database. One of the columns in this result set is named "DATA_TYPE", which is the same value as the type's java.sql.Types value