Data Types and Storage of Values

Data Types and Storage of Values

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

Data Types and Storage of Values

ALPHA/CHAR and VARALPHA/ VARCHAR Values

If an ALPHA or CHAR object is assigned the value abc///// (with five trailing blanks), it is stored as abc///// (fixed length value).

If a VARALPHA or VARCHAR object is assigned the value abc/////, it is stored as abc without any trailing blanks, but with an indicator that gives the length of the value (variable length value).

Maximum Lenth for ALPHA/CHAR and VARALPHA/VARCHAR

 

ALPHACHARVARAPLHAVARCHAR
32767 bytes32767 bytes32767 bytes32767 bytes

INT and LONGINT Values

INT, LONGINT and VASTINT values are stored “without decimals”. Actually, the decimal information is stored separately.

The “non-decimal” value (value of the significant digits) must fall within the range of the applicable data type.

Examples – INT Values

ValueSignificant DigitsNumber of DecimalsValid Maximum/Minimum Values
123.4123413276.7 / -3276.8
12.3412342327.67 / -327.68
12.341234332.767 / -32.768
0.01234123450.32767 / -0.32768

Examples – LONGINT Values

ValueSignificant DigitsNumber of DecimalsValid Maximum/Minimum Values
1.23456123456521474.83647 / -21474.83647
1234.56123456221474836.47 / -21474836.47

See Also

About Conditional Expressions

Conversion Between Data Types

Data Types and the Use of Database Indexes

How To Use Data Types

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

pt_BRPortuguese