HPlogo HP Driver for JDBC User's Manual: HP 3000 MPE/iX Computer Systems > Chapter 5 ALLBASE/SQL Specifics

ALLBASE/SQL to JDBC Data Type Mapping

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Table 5-1 “Data Type Mapping” shows what the HP Driver for JDBC will report as the JDBC data type for each ALLBASE/SQL data type. These are the java.sql.Types values that will be returned from the java.sql.ResultSetMetaData.getColumnType method. An "X" in the column indicates the data type mapping.

A description of each ALLBASE/SQL and JDBC data type can be found in Appendix A “Data Types”

Table 5-1 Data Type Mapping

JDBC DATA TYPES (vertical)

TINYINTSMALLINT

INTEGER

BIGINTREALFLOATDOUBLEDECIMALNUMERICBITCHARVARCHARLONGVARCHARBINARYVARBINARYLONGVARBINARYDATETIMETIMESTAMP

ALLBASE/SQL DATA TYPES (horizontal)

SMALLINT (16-bits)

X

  

 

        

  

INTEGER (32-bits)

X

REAL

X

FLOAT(1...24)

X 

FLOAT(25...53)

X

DOUBLE PRECISION

X

DECIMAL

X

  

NUMERIC

X

CHAR

X

VARCHAR

X

DATE

X

TIME

X

DATETIME

X

INTERVAL

X

 

Feedback to webmaster