Java data types correspond to DB2, Oracle, Sybase, and SQL Server

Source: Internet
Author: User
Tags db2 ibm db2 sybase

 java.sql.types java  IBM DB2  oracle  sybase  sql-server
bigint JAVA.LANG.LONG  BIGINT  number (0)   bigint BIGINT 
binary byte[] char for BIT DATA raw Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">binary image
bit Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">java.lang.boolean n/a bit bit bit
blob Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">BYTE[]  BLOB  blob BLOB blob
CHAR  java.lang.string  char, GRAPHIC char  char char
clob Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">JAVA.LANG.STRING   clob, Dbclob clob CLOB  CLOB 
date Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">java.sql.date  date date DATE date
decimal java.math.bigdecimal DECIMAL  number decimal, Money, smallmoney   decimal 
double java.lang.double double  double PRECISION double precision  double PRECISION
float java.lang.double  float float FLOAT  FLOAT 
 integer java.lang.integer   integer  integer int INTEGER 
 java_object   Java.lang.Object Java_object Java_object Java_object Java_object
longvarbinary  byte[] long VARCHAR for BIT DATA   LONG RAW image   image
longvarchar  java.lang.string long VARCHAR, LONG vargraphic long text text
 numeric java.math.bigdecimal numeric numeric numeric numeric
 other java.lang.object      other   other   other  OTHER 
 real java.lang.float real real real real
 smallint java.lang.integer smallint smallint smallint smallint
 time java.sql.time time date time time
 timestamp java.sql.timestamp timestamp  date datetime, smalldatetime datetime
 tinyint java.lang.bute smallint tinyint tinyint tinyint
 varbinary byte[" varchar for BIT DATA raw varbinary image
VARCHAR Java.lang.String VARCHAR, Vargraphic VARCHAR VARCHAR VARCHAR

Java data types correspond to DB2, Oracle, Sybase, and SQL Server

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.