Storage Types

The the following storage types are defined in libgda:

  • null

  • bigint

  • biguint

  • binary

  • blob

  • boolean

  • date

  • double

  • geometric_point (point)

  • gobject

  • integer

  • list

  • money

  • numeric

  • single

  • smallint

  • smalluint

  • string

  • time

  • timestamp

  • tinyint

  • tinyuint

  • type

  • uinteger

  • unknown

Not all storage types are implemented (yet) and/or supported in all the various providers libgda can link with.

Within the ProLinga 4GL environment, only the basic data storage types are defined:

  • Character

  • Integer

  • Long (Integer)

  • Single (Precision Number)

  • Double (Precision Number)

  • Date

Table 2. ProLinga 4GL -> libgda mapping

ProLinga Storage TypeLibGDA Storage Type
Characterstring
Integerinteger
Long Integerbigint
Single Precision Numbersingle
Double Precision Numberdouble
Datedate

Table 3. libgda -> ProLinga 4GL mapping

LibGDA Storage TypeProLinga Storage Type
nullCharacter
bigintLong Integer
biguint (not implemented yet in libgda)--
binaryCharacter
blobCharacter
booleanCharacter
dateDate
doubleDouble Precision Number
geometric_point (point)N/A
gobject (not implemented yet in libgda)--
listN/A
money (not implemented yet in libgda)--
numericDouble Precision Number
singleSingle Precision Number
smallintInteger
smalluint (not implemented yet in libgda)--
stringCharacter
timeCharacter
timestampCharacter
tinyintInteger
tinyuint (not implemented yet in libgda)--
type (not implemented yet in libgda)--
uinteger (not implemented yet in libgda)--
unknown (not implemented yet in libgda)--

For libgda <-> data provider mappings, please look at provider specific documentation at http://www.gnome-db.org.