Choose Appropriate Data Types

Take care when selecting attribute types.

• Be aware of the value space of the default Signed Integer sub-type [-231,231-1]. If it is insufficient, use the Fixed Integer type.
• Be aware of the limitations of the default Floating Point Decimal sub-type - 16 significant digits. Limitation of accuracy and rounding issues may indicate that it is not suitable for handling large values.
• Remember that when you are converting a data item from one type to another, either explicitly or implicitly, it is possible to exceed the limitations of the target type and generate an error. See Business Data Scripting by Example for examples of conversion limitations.
• With Datetime types if a timezone is required, use Datetimetz.

Copyright © Cloud Software Group, Inc. All rights reserved.