String types
Updated at:
PolarDB-X 1.0 supports the MySQL 5.7 string data types. Use these types to store character strings, binary strings, and enumerated values.
Supported types
| Type | Description |
|---|---|
| CHAR and VARCHAR | Fixed-length and variable-length character strings. |
| BINARY and VARBINARY | Fixed-length and variable-length binary strings, similar to CHAR and VARCHAR but storing raw bytes rather than characters. |
| BLOB and TEXT | Large-object types for binary data (BLOB) and character data (TEXT). |
| ENUM | A string with a value chosen from a predefined list. |
| SET | A string that can hold zero or more values from a predefined list. |
For full syntax, storage requirements, and character set interactions, see String data types in the MySQL 5.7 Reference Manual.
Is this page helpful?