Jump to: navigation, search

CfgDataType

Values

Mnemonic ID Flag Short Description Log Name Long Description
CFGDTNoDataType 0 0 'Unknown Data Type' NoDataType The value of corresponding parameter is not changed.
CFGDTInt 1 0 'int' Int A data base data type that is an integer column that holds whole numbers between 231 -1 (that is, 2,147,483,647) and -231 (that is, -2,147,483,648), inclusive.
CFGDTFloat 2 0 'float' Float A data base data type. It is a floating-point column that holds positive or negative floating-point numbers. This column has 15-digit precision. The range of values is approximately 1.7E - 308 to 1.7E 308.
CFGDTChar 3 0 'char' Char A character data type that holds a maximum of 255 characters. Specify the maximum length with n. The char datatype can contain 0 characters, but when specified, n must be a value from 1 through 255. Storage size is n regardless of the actual length of the entry. Choose char when you think the data entries in the column will be consistently close to the same size. Columns of type char are accessed somewhat faster than varchar columns because they use a fixed storage length (n).
CFGDTVarChar 4 0 'varchar' VarChar A data base data type, varchar(n) is a column of variable-length characters that holds any combination of up to 255 letters, symbols, and numbers. Specify the maximum size of the column with n. A char column can contain 0 characters, but n must be between 1 and 255, inclusive. Storage size is the actual size of the data values entered, not n. Because of the way it uses space, varchar is best suited for data-like names, where the length of each entry can vary considerably. But varchar imposes more overhead than char, so if the length is fairly consistent, use char instead. Data of type varchar must be enclosed in single quotation marks when it is input. To have a truly empty sting, insert the keyword NULL rather than an empty string, such as ' '. You can use the LIKE keyword and wildcard characters with varchar. If you enter strings that are too long for the specified length, varchar entries are truncated.
CFGDTDateTime 5 0 'datetime' DateTime A data base data type. A datetime datatype is stored in 8 bytes of two 4-byte integers: 4 bytes for the number of days before or after the base date of January 1, 1900, and 4 bytes for the number of milliseconds after midnight. The date segments of datetime values representing dates prior to the base date are stored as negative values.

Comments

An identifier that specifies what type of information a column holds and how the data is stored. The CfgDataType is applicable for Configuration Library/Server release 5.1.5xx only.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 27 June 2017, at 13:20.