Standard SQL Data Types with Their Java Equivalents : Database Type vs Java Type « Database SQL JDBC « Java

Home
Java
1.2D Graphics GUI
2.3D
3.Advanced Graphics
4.Ant
5.Apache Common
6.Chart
7.Class
8.Collections Data Structure
9.Data Type
10.Database SQL JDBC
11.Design Pattern
12.Development Class
13.EJB3
14.Email
15.Event
16.File Input Output
17.Game
18.Generics
19.GWT
20.Hibernate
21.I18N
22.J2EE
23.J2ME
24.JDK 6
25.JNDI LDAP
26.JPA
27.JSP
28.JSTL
29.Language Basics
30.Network Protocol
31.PDF RTF
32.Reflection
33.Regular Expressions
34.Scripting
35.Security
36.Servlets
37.Spring
38.Swing Components
39.Swing JFC
40.SWT JFace Eclipse
41.Threads
42.Tiny Application
43.Velocity
44.Web Services SOA
45.XML
Java » Database SQL JDBC » Database Type vs Java TypeScreenshots 
Standard SQL Data Types with Their Java Equivalents
 

SQL type            Java Type                 Description

BINARY              byte[]                    Byte array. Used for binary large objects.

BIT                 boolean                   Boolean value

CHAR                String                    Fixed-length character string. 

DATETIME            java.sql.Date             Date and Time as: yyyy-mm-dd hh:mm:ss

DECIMAL             java.math.BigDecimal      Arbitrary-precision signed decimal numbers. 

FLOAT               double                    Floating-point number, mapped to double

INTEGER             int                       32-bit integer values

LONGVARBINARY       byte[]                    Variable-length character string. 

LONGVARCHAR         String                    Variable-length character string. 

NCHAR               String                    National Character Unicode fixed-length character string

NUMERIC             java.math.BigDecimal      Arbitrary-precision signed decimal numbers. 

NTEXT               String                    Large string variables. 

NVARCHAR            String                    National Character Unicode variable-length character string

REAL                float                     Floating-point number, mapped to float

SMALLINT            short                     16-bit integer values

TIME                java.sql.Time             Thin wrapper around java.util.Date

TIMESTAMP           java.sql.Timestamp        Composite of a java.util.Date and a separate nanosecond value

VARBINARY           byte[]                    Byte array

VARCHAR             String                    Variable-length character string. 

 
Related examples in the same category
1.Get Available Table Types
2.All data types for Oracle
3.Create Table With All Data Types In MySQL
4.Get Available Sql Types In A Database
5.Sql DateTime
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.