613-518-1166 info@zimdatabases.com

Developing ZIM Applications

Character Data Types

< All Topics

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 Type

Data Length

Treatment of Letter Case

ALPHA

Fixed (padded with trailing blanks if necessary)

Case insensitive (but, case is stored and visible on display)

VARALPHA

Variable

Case insensitive (but, case is stored and visible on display)

CHAR

Fixed (padded with trailing blanks if necessary)

Case insensitive

VARCHAR

Variable

Case 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%
How can we improve this article?
Table of Contents