Home  >  Article  >  Database  >  What data types does JDBC support?

What data types does JDBC support?

王林
王林forward
2023-09-07 13:57:021391browse

What data types does JDBC support?

JDBC provides support for almost all SQL data types. Whenever the JDBC driver receives a call from a Java application, it converts the Java data types in it to the corresponding SQL type of data. The conversion process follows the default mapping. The following is a list of data types supported by JDBC and their corresponding SQL data types.

##VARCHAR java.lang.StringCHARjava.lang.StringLONGVARCHARjava. lang.StringBITBoolean##NUMERICTINYINTSMALLINTInteger##BIGINTLongREALFloating point FLOATFloating pointDouble precisionDouble precisionVARBINARYbyte[]Binarybyte[]Datejava.sql.DateTIMEjava.sql.TimeTIMESTAMP java.sql. TimestampCLOBjava.sql.ClobBLOB java.sql.Blob ARRAYjava.sql.ArrayREFjava.sql.RefSTRUCTjava.sql.Struct
SQL JDBC/Java
java.math.BigDecimal
bytes
Short
int

The above is the detailed content of What data types does JDBC support?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete