Character Data Types
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
Character Data Types
0 out of 5 stars
| 5 Stars | 0% | |
| 4 Stars | 0% | |
| 3 Stars | 0% | |
| 2 Stars | 0% | |
| 1 Stars | 0% |
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
Data Types and Storage of Values
Updated
ByJason Lee
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
Portuguese 
English