How Can We Help?
< All Topics
Print

Character Data Types

Each character data type represents a particular combination of storage space usage and letter case treatment. ALPHA, VARALPHA, CHAR, and VARCHAR values can contain letters, digits, spaces, symbols, and hexadecimal codes.

Character Data Type Characteristics

Data TypeData LengthTreatment of Letter Case
ALPHAFixed (padded with trailing blanks if necessary)Case insensitive (but, case is stored and visible on display)
VARALPHAVariableCase insensitive (but, case is stored and visible on display)
CHARFixed (padded with trailing blanks if necessary)Case insensitive
VARCHARVariableCase insensitive

See Also

About Conditional Expressions

Conversion Between Data Types

Data Types and Storage of Values

Data Types and the Use of Database Indexes

How To Use Data Types

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish