Text
Core supports six primary text-based field types:
- Varchar
- Integer
- Float
- Decimal
- Double
- Text Area
These field types are used to store different kinds of textual and numeric data.
1. Varchar
- Stores: Variable-length text
- Content: Letters, numbers, symbols, emojis, and multilingual characters (UTF-8 / utf8mb4)
- Length: Configurable
Use Varchar when
Storing short to medium text values such as:
- Names
- Titles
- Short descriptions
- User input
2. Integer
- Stores: Whole numbers
- Content: Positive or negative integers (no decimals)
- Precision: Exact
Use Integer when
Storing discrete numeric values such as:
- Counts
- IDs
- Quantities
- Index values
3. Float
- Stores: Approximate decimal numbers
- Precision: ~7 digits
- Accuracy: May introduce small rounding errors
Use Float when
Precision is not critical, such as:
- Measurements
- Scientific approximations
- General calculations
4. Decimal
- Stores: Exact decimal numbers
- Precision: Fully accurate (no floating-point rounding errors)
- Format: Fixed precision defined by scale and precision settings
Use Decimal when
Accuracy is important, such as:
- Currency values
- Financial data
- Precise calculations
5. Double
- Stores: High-precision decimal numbers
- Precision: ~15 digits
- Accuracy: More precise than Float, but still approximate
Use Double when
Handling more complex numeric calculations, such as:
- Engineering data
- Analytical computations
- High-precision measurements
6. Text Area
- Stores: Longer text content
- Length: Up to 2048 characters
- Content: UTF-8 supported text (same as Varchar)
Use Text Area when
Storing extended text such as:
- Comments
- Notes
- Detailed descriptions