Character Data Types

Character Data Types

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< 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

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.

Leave a Reply

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

en_CAEnglish