Database.HDBC.ColTypes

Definitions of, and utilities for, specifying what type of data is represented by a column.

Written by John Goerzen, [e-mail]

Documentation

data SqlColDesc

The description of a column.

Fields are Nothing if the database backend cannot supply the requested information.

The colSize field works like this:

For character types, the maximum width of the column. For numeric types, the total number of digits allowed. See the ODBC manual for more.

The colOctetLength field is defined for character and binary types, and gives the number of bytes the column requires, regardless of encoding.

Constructors

SqlColDesc

Fields

• colType :: SqlTypeId

  Type of data stored here

• colSize :: Maybe Int

  The size of a column

• colOctetLength :: Maybe Int

  The maximum size in octets

• colDecDigits :: Maybe Int

  Digits to the right of the period

• colNullable :: Maybe Bool

  Whether NULL is acceptable

Instances

Eq SqlColDesc

Defined in Database.HDBC.ColTypes

Methods

(==) :: SqlColDesc -> SqlColDesc -> Bool

(/=) :: SqlColDesc -> SqlColDesc -> Bool

Read SqlColDesc

Defined in Database.HDBC.ColTypes

Methods

readsPrec :: Int -> ReadS SqlColDesc

readList :: ReadS [SqlColDesc]

readPrec :: ReadPrec SqlColDesc

readListPrec :: ReadPrec [SqlColDesc]

Show SqlColDesc

Defined in Database.HDBC.ColTypes

Methods

showsPrec :: Int -> SqlColDesc -> ShowS

show :: SqlColDesc -> String

showList :: [SqlColDesc] -> ShowS

data SqlTypeId

The type identifier for a given column.

This represents the type of data stored in the column in the underlying SQL engine. It does not form the entire column type; see SqlColDesc for that.

These types correspond mainly to those defined by ODBC.

Constructors

SqlCharT

Fixed-width character strings

SqlVarCharT

Variable-width character strings

SqlLongVarCharT

Variable-width character strings, max length implementation dependant

SqlWCharT

Fixed-width Unicode strings

SqlWVarCharT

Variable-width Unicode strings

SqlWLongVarCharT

Variable-width Unicode strings, max length implementation dependant

SqlDecimalT

Signed exact values

SqlNumericT

Signed exact integer values

SqlSmallIntT

16-bit integer values

SqlIntegerT

32-bit integer values

SqlRealT

SqlFloatT

Signed inexact floating-point values

SqlDoubleT

Signed inexact double-precision values

SqlBitT

A single bit

SqlTinyIntT

8-bit integer values

SqlBigIntT

64-bit integer values

SqlBinaryT

Fixed-length binary data

SqlVarBinaryT

Variable-length binary data

SqlLongVarBinaryT

Variable-length binary data, max length implementation dependant

SqlDateT

A date

SqlTimeT

A time, no timezone

SqlTimeWithZoneT

A time, with timezone

SqlTimestampT

Combined date and time, no timezone

SqlTimestampWithZoneT

Combined date and time, with timezone

SqlUTCDateTimeT

UTC date/time

SqlUTCTimeT

UTC time

SqlIntervalT SqlInterval

A time or date difference

SqlGUIDT

Global unique identifier

SqlUnknownT String

A type not represented here; implementation-specific information in the String

Instances

Eq SqlTypeId

Defined in Database.HDBC.ColTypes

Methods

(==) :: SqlTypeId -> SqlTypeId -> Bool

(/=) :: SqlTypeId -> SqlTypeId -> Bool

Read SqlTypeId

Defined in Database.HDBC.ColTypes

Methods

readsPrec :: Int -> ReadS SqlTypeId

readList :: ReadS [SqlTypeId]

readPrec :: ReadPrec SqlTypeId

readListPrec :: ReadPrec [SqlTypeId]

Show SqlTypeId

Defined in Database.HDBC.ColTypes

Methods

showsPrec :: Int -> SqlTypeId -> ShowS

show :: SqlTypeId -> String

showList :: [SqlTypeId] -> ShowS

data SqlInterval

The different types of intervals in SQL.

Constructors

SqlIntervalMonthT

Difference in months

SqlIntervalYearT

Difference in years

SqlIntervalYearToMonthT

Difference in years+months

SqlIntervalDayT

Difference in days

SqlIntervalHourT

Difference in hours

SqlIntervalMinuteT

Difference in minutes

SqlIntervalSecondT

Difference in seconds

SqlIntervalDayToHourT

Difference in days+hours

SqlIntervalDayToMinuteT

Difference in days+minutes

SqlIntervalDayToSecondT

Difference in days+seconds

SqlIntervalHourToMinuteT

Difference in hours+minutes

SqlIntervalHourToSecondT

Difference in hours+seconds

SqlIntervalMinuteToSecondT

Difference in minutes+seconds

Instances

Eq SqlInterval

Defined in Database.HDBC.ColTypes

Methods

(==) :: SqlInterval -> SqlInterval -> Bool

(/=) :: SqlInterval -> SqlInterval -> Bool

Read SqlInterval

Defined in Database.HDBC.ColTypes

Methods

readsPrec :: Int -> ReadS SqlInterval

readList :: ReadS [SqlInterval]

readPrec :: ReadPrec SqlInterval

readListPrec :: ReadPrec [SqlInterval]

Show SqlInterval

Defined in Database.HDBC.ColTypes

Methods

showsPrec :: Int -> SqlInterval -> ShowS

show :: SqlInterval -> String

showList :: [SqlInterval] -> ShowS