HDBC-2.4.0.4: Haskell Database Connectivity
CopyrightCopyright (C) 2006-2011 John Goerzen
LicenseBSD3
MaintainerJohn Goerzen <jgoerzen@complete.org>
Stabilityprovisional
Portabilityportable
Safe HaskellSafe-Inferred
LanguageHaskell2010

Database.HDBC.ColTypes

Description

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

Written by John Goerzen, jgoerzen@complete.org

Synopsis

Documentation

data SqlColDesc Source #

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

data SqlTypeId Source #

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

Instances details
Eq SqlTypeId Source # 
Instance details

Defined in Database.HDBC.ColTypes

Read SqlTypeId Source # 
Instance details

Defined in Database.HDBC.ColTypes

Show SqlTypeId Source # 
Instance details

Defined in Database.HDBC.ColTypes

data SqlInterval Source #

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