Documentation: Standard Datatypes
Standard datatypes are used for formatting and sorting of elementary
datatypes often used in websites and web-apps.
Formatting can be localized by setting a "locale" (see examples for
localization in the documentation for xw-browse).
- string
Arbitrary sequence of characters without special formatting; values are sorted
using the standard Javascript compare-function "localeCompare" for strings. - date
Values are expected to be in JDBC-Date-Format ("YYYY-MM-DD").
Formatting can be controlled by localization. - datetime
Date and time; values are expected to start with JDBC-Datetime-Format
("YYYY-MM-DD HH:MM:SS"). Formatting can be controlled by localization. - datetimemin
As "datetime", but values are formatted without seconds. - int
Number of type integer; formatting can be controlled by localization. - float
Floating-point number; formatting can be controlled by localization. - money
Amount of money with 2 fractional digits; formatting can be controlled by localization. - bool
Formatting of boolean values ("true" / "false"), can be controlled by localization.
Because boolean values are often likely to be formatted graphically (e.g. with a
check mark), there is a possibility to replace globally the formatting function
xw.formatBool for boolean values (see demo for xw-browse). Also see documentation for property "formatter" in Initialization-Object of xw-browse and function xw.select() in library xw.js ).
