| SQL adaptation guide For Oracle MySQL 5.x / Data dictionary | |
Informix® uses the TEXT and BYTE data types to store very large texts or images. MySQL provides TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB data types.
Starting with MySQL version 5.0, the database interface can convert BDL TEXT data to LONGTEXT and BYTE data to LONG BLOB.
Genero TEXT/BYTE program variables have a limit of 2 gigabytes, make sure that the large object data does not exceed this limit.
Because MySQL CHAR and VARCHAR cannot exceed 255 bytes, we recommend that you use the MySQL TEXT type to store CHAR/VARCHAR values with a size larger than 255 bytes. When fetching TEXT columns from a MySQL database, these will be treated as CHAR/VARCHAR types by the MySQL database driver. See CHAR/VARCHAR types for more details.