net.sourceforge.jtds.jdbc
Class TdsData.TypeInfo

java.lang.Object
  net.sourceforge.jtds.jdbc.TdsData.TypeInfo

Enclosing class:

TdsData

private static class TdsData.TypeInfo

extends java.lang.Object

This class implements a descriptor for TDS data types;

Author:

Mike Hutchinson.

Field Summary

int	displaySize The display size of the type.
boolean	isCollation true if type requires TDS80 collation.
boolean	isSigned true if type is a signed numeric.
int	jdbcType The java.sql.Types constant for this data type.
int	precision The precision of the type.
int	size The size of this type or < 0 for variable sizes.
java.lang.String	sqlType The SQL type name.

Constructor Summary

(package private)

TdsData.TypeInfo(java.lang.String sqlType, int size, int precision, int displaySize, boolean isSigned, boolean isCollation, int jdbcType) Construct a new TDS data type descriptor.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

sqlType

public final java.lang.String sqlType

The SQL type name.

size

public final int size

The size of this type or < 0 for variable sizes.

Special values as follows:

1. -5 sql_variant type.
2. -4 text, image or ntext types.
3. -2 SQL Server 7+ long char and var binary types.
4. -1 varchar, varbinary, null types.

precision

public final int precision

The precision of the type.

If this is -1 precision must be calculated from buffer size eg for varchar fields.

displaySize

public final int displaySize

The display size of the type.

-1 If the display size must be calculated from the buffer size.

isSigned

public final boolean isSigned

true if type is a signed numeric.

isCollation

public final boolean isCollation

true if type requires TDS80 collation.

jdbcType

public final int jdbcType

The java.sql.Types constant for this data type.

Constructor Detail

TdsData.TypeInfo

TdsData.TypeInfo(java.lang.String sqlType,
                 int size,
                 int precision,
                 int displaySize,
                 boolean isSigned,
                 boolean isCollation,
                 int jdbcType)

Construct a new TDS data type descriptor.

Parameters:

sqlType - SQL type name.

size - Byte size for this type or < 0 for variable length types.

precision - Decimal precision or -1

displaySize - Printout size for this type or special values -1,-2.

isSigned - True if signed numeric type.

isCollation - True if type has TDS 8 collation information.

jdbcType - The java.sql.Type constant for this type.