The following table lists the string data types available in MySQL and shows whether or not they are available in Oracle, PostgreSQL, and SQL Server:
NOTE: The size allowances on SQL Server, PostgreSQL, and Oracle may be different even if the data type name is the same.
String data types in MySQL | Also available in | ||
Data Type | SQL Server | PostgreSQL | Oracle |
CHAR | Yes | Yes | Yes |
VARCHAR | Yes | Yes | Yes |
BINARY | Yes | No | No |
VARBINARY | Yes | No | No |
BLOB | No | No | No |
TINYBLOB | No | No | No |
MEDIUMBLOB | No | No | No |
LONGBLOB | No | No | No |
TEXT | Yes | Yes | No |
TINYTEXT | No | No | No |
MEDIUMTEXT | No | No | No |
LONGTEXT | No | No | No |
ENUM | No | No | No |
SET | No | No | No |