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.JavaFX
25.JDK 6
26.JDK 7
27.JNDI LDAP
28.JPA
29.JSP
30.JSTL
31.Language Basics
32.Network Protocol
33.PDF RTF
34.Reflection
35.Regular Expressions
36.Scripting
37.Security
38.Servlets
39.Spring
40.Swing Components
41.Swing JFC
42.SWT JFace Eclipse
43.Threads
44.Tiny Application
45.Velocity
46.Web Services SOA
47.XML
Java » Database SQL JDBC » Database Type vs Java Type 




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.