Child pages
  • Column Properties

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

While relation databases support many different data types, Servoy will generalize the data type of a column into one of five general types. In this way, Servoy can support a wide range of database vendors. The five generalized data types include the following:

  1. TextTEXT: Any alpha-numeric characters (i.e. char, varchar, memo, CLOB, etc.)
  2. IntegerINTEGER: Whole numbers (i.e. bit, short, long, bigint, etc.)
  3. NumberNUMBER: Decimal numbers (i.e. float, double, etc)
  4. DatetimeDATETIME: Temporal values (i.e. date, datetime, timestamp, etc.)
  5. MediaMEDIA: Binary data (i.e. BLOB)

...