A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Datatypes: Decimal Datatypes

double precision

The term double precision describes a datatype, or more precisely a decimal datatype. Like all decimal datatypes, the datatype double precision is also based on the ANSI standard. The datatype double precision requires 8 bytes of storage. Allowed values are decimal numbers. Their range of values is machine dependent.

Usage of the datatype double precision

The datatype double precision is used only if rounded values do not cause problems. In all other cases, more acurate datatypes should be used, because with decimal datatypes, depending on the method of calculation, the number behind the decimal point could be rounded. For example the ASE client application isql only displays an accuracy of six digits after the decimal point. The following numbers are accordingly rounded up or down.