include/master-slave.inc [connection master] set @saved_slave_type_conversions = @@global.slave_type_conversions; CREATE TABLE type_conversions ( TestNo INT AUTO_INCREMENT PRIMARY KEY, Source TEXT, Target TEXT, Flags TEXT, On_Master TEXT, On_Slave TEXT, Expected TEXT, Compare INT, Error TEXT); SELECT @@global.slave_type_conversions; @@global.slave_type_conversions SET GLOBAL SLAVE_TYPE_CONVERSIONS=''; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_NON_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_LOSSY,ALL_NON_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY,NONEXISTING_BIT'; ERROR 42000: Variable 'slave_type_conversions' can't be set to the value of 'NONEXISTING_BIT' SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_LOSSY,ALL_NON_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS=''; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = '' **** include/rpl_reset.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY' **** include/rpl_reset.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY' **** include/rpl_reset.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY,ALL_NON_LOSSY' **** include/rpl_reset.inc **** Result of conversions **** Source_Type Target_Type All_Type_Conversion_Flags Value_On_Slave GEOMETRY GEOMETRY BIT(1) BIT(1) DATE DATE ENUM('master',' ENUM('master',' CHAR(10) ENUM('master',' CHAR(10) SET('master','s ENUM('master',' CHAR(10) SET('master','s CHAR(10) SET('master','s SET('master','s SET('master','s SET('master','s SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' TINYINT TINYINT TINYINT SMALLINT TINYINT MEDIUMINT TINYINT INT TINYINT BIGINT SMALLINT TINYINT SMALLINT TINYINT SMALLINT TINYINT UNSIGNE SMALLINT SMALLINT SMALLINT MEDIUMINT SMALLINT INT SMALLINT BIGINT MEDIUMINT TINYINT MEDIUMINT TINYINT MEDIUMINT TINYINT UNSIGNE MEDIUMINT SMALLINT MEDIUMINT MEDIUMINT MEDIUMINT INT MEDIUMINT BIGINT INT TINYINT INT TINYINT INT TINYINT UNSIGNE INT SMALLINT INT MEDIUMINT INT INT INT BIGINT BIGINT TINYINT BIGINT SMALLINT BIGINT MEDIUMINT BIGINT INT BIGINT BIGINT CHAR(20) CHAR(20) CHAR(20) CHAR(30) CHAR(20) CHAR(10) CHAR(20) VARCHAR(20) CHAR(20) VARCHAR(30) CHAR(20) VARCHAR(10) CHAR(20) TINYTEXT CHAR(20) TEXT CHAR(20) MEDIUMTEXT CHAR(20) LONGTEXT VARCHAR(20) VARCHAR(20) VARCHAR(20) VARCHAR(30) VARCHAR(20) VARCHAR(10) VARCHAR(20) CHAR(30) VARCHAR(20) CHAR(10) VARCHAR(20) TINYTEXT VARCHAR(20) TEXT VARCHAR(20) MEDIUMTEXT VARCHAR(20) LONGTEXT VARCHAR(500) VARCHAR(500) VARCHAR(500) VARCHAR(510) VARCHAR(500) VARCHAR(255) VARCHAR(500) TINYTEXT VARCHAR(500) TEXT VARCHAR(500) MEDIUMTEXT VARCHAR(500) LONGTEXT TINYTEXT VARCHAR(500) TEXT VARCHAR(500) MEDIUMTEXT VARCHAR(500) LONGTEXT VARCHAR(500) TINYTEXT CHAR(255) TINYTEXT CHAR(250) TEXT CHAR(255) MEDIUMTEXT CHAR(255) LONGTEXT CHAR(255) TINYTEXT TINYTEXT TINYTEXT TEXT TEXT TINYTEXT DECIMAL(10,5) DECIMAL(10,5) DECIMAL(10,5) DECIMAL(10,6) DECIMAL(10,5) DECIMAL(11,5) DECIMAL(10,5) DECIMAL(11,6) DECIMAL(10,5) DECIMAL(10,4) DECIMAL(10,5) DECIMAL(9,5) DECIMAL(10,5) DECIMAL(9,4) FLOAT DECIMAL(10,5) DOUBLE DECIMAL(10,5) DECIMAL(10,5) FLOAT DECIMAL(10,5) DOUBLE FLOAT FLOAT DOUBLE DOUBLE FLOAT DOUBLE DOUBLE FLOAT BIT(5) BIT(5) BIT(5) BIT(6) BIT(6) BIT(5) BIT(5) BIT(12) BIT(12) BIT(5) GEOMETRY GEOMETRY ALL_NON_LOSSY BIT(1) BIT(1) ALL_NON_LOSSY DATE DATE ALL_NON_LOSSY ENUM('master',' ENUM('master',' ALL_NON_LOSSY CHAR(10) ENUM('master',' ALL_NON_LOSSY CHAR(10) SET('master','s ALL_NON_LOSSY ENUM('master',' CHAR(10) ALL_NON_LOSSY SET('master','s CHAR(10) ALL_NON_LOSSY SET('master','s SET('master','s ALL_NON_LOSSY SET('master','s SET('master','s ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY TINYINT TINYINT ALL_NON_LOSSY TINYINT SMALLINT ALL_NON_LOSSY TINYINT MEDIUMINT ALL_NON_LOSSY TINYINT INT ALL_NON_LOSSY TINYINT BIGINT ALL_NON_LOSSY SMALLINT TINYINT ALL_NON_LOSSY SMALLINT TINYINT ALL_NON_LOSSY SMALLINT TINYINT UNSIGNE ALL_NON_LOSSY SMALLINT SMALLINT ALL_NON_LOSSY SMALLINT MEDIUMINT ALL_NON_LOSSY SMALLINT INT ALL_NON_LOSSY SMALLINT BIGINT ALL_NON_LOSSY MEDIUMINT TINYINT ALL_NON_LOSSY MEDIUMINT TINYINT ALL_NON_LOSSY MEDIUMINT TINYINT UNSIGNE ALL_NON_LOSSY MEDIUMINT SMALLINT ALL_NON_LOSSY MEDIUMINT MEDIUMINT ALL_NON_LOSSY MEDIUMINT INT ALL_NON_LOSSY MEDIUMINT BIGINT ALL_NON_LOSSY INT TINYINT ALL_NON_LOSSY INT TINYINT ALL_NON_LOSSY INT TINYINT UNSIGNE ALL_NON_LOSSY INT SMALLINT ALL_NON_LOSSY INT MEDIUMINT ALL_NON_LOSSY INT INT ALL_NON_LOSSY INT BIGINT ALL_NON_LOSSY BIGINT TINYINT ALL_NON_LOSSY BIGINT SMALLINT ALL_NON_LOSSY BIGINT MEDIUMINT ALL_NON_LOSSY BIGINT INT ALL_NON_LOSSY BIGINT BIGINT ALL_NON_LOSSY CHAR(20) CHAR(20) ALL_NON_LOSSY CHAR(20) CHAR(30) ALL_NON_LOSSY CHAR(20) CHAR(10) ALL_NON_LOSSY CHAR(20) VARCHAR(20) ALL_NON_LOSSY CHAR(20) VARCHAR(30) ALL_NON_LOSSY CHAR(20) VARCHAR(10) ALL_NON_LOSSY CHAR(20) TINYTEXT ALL_NON_LOSSY CHAR(20) TEXT ALL_NON_LOSSY CHAR(20) MEDIUMTEXT ALL_NON_LOSSY CHAR(20) LONGTEXT ALL_NON_LOSSY VARCHAR(20) VARCHAR(20) ALL_NON_LOSSY VARCHAR(20) VARCHAR(30) ALL_NON_LOSSY VARCHAR(20) VARCHAR(10) ALL_NON_LOSSY VARCHAR(20) CHAR(30) ALL_NON_LOSSY VARCHAR(20) CHAR(10) ALL_NON_LOSSY VARCHAR(20) TINYTEXT ALL_NON_LOSSY VARCHAR(20) TEXT ALL_NON_LOSSY VARCHAR(20) MEDIUMTEXT ALL_NON_LOSSY VARCHAR(20) LONGTEXT ALL_NON_LOSSY VARCHAR(500) VARCHAR(500) ALL_NON_LOSSY VARCHAR(500) VARCHAR(510) ALL_NON_LOSSY VARCHAR(500) VARCHAR(255) ALL_NON_LOSSY VARCHAR(500) TINYTEXT ALL_NON_LOSSY VARCHAR(500) TEXT ALL_NON_LOSSY VARCHAR(500) MEDIUMTEXT ALL_NON_LOSSY VARCHAR(500) LONGTEXT ALL_NON_LOSSY TINYTEXT VARCHAR(500) ALL_NON_LOSSY TEXT VARCHAR(500) ALL_NON_LOSSY MEDIUMTEXT VARCHAR(500) ALL_NON_LOSSY LONGTEXT VARCHAR(500) ALL_NON_LOSSY TINYTEXT CHAR(255) ALL_NON_LOSSY TINYTEXT CHAR(250) ALL_NON_LOSSY TEXT CHAR(255) ALL_NON_LOSSY MEDIUMTEXT CHAR(255) ALL_NON_LOSSY LONGTEXT CHAR(255) ALL_NON_LOSSY TINYTEXT TINYTEXT ALL_NON_LOSSY TINYTEXT TEXT ALL_NON_LOSSY TEXT TINYTEXT ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,5) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,6) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(11,5) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(11,6) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,4) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(9,5) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(9,4) ALL_NON_LOSSY FLOAT DECIMAL(10,5) ALL_NON_LOSSY DOUBLE DECIMAL(10,5) ALL_NON_LOSSY DECIMAL(10,5) FLOAT ALL_NON_LOSSY DECIMAL(10,5) DOUBLE ALL_NON_LOSSY FLOAT FLOAT ALL_NON_LOSSY DOUBLE DOUBLE ALL_NON_LOSSY FLOAT DOUBLE ALL_NON_LOSSY DOUBLE FLOAT ALL_NON_LOSSY BIT(5) BIT(5) ALL_NON_LOSSY BIT(5) BIT(6) ALL_NON_LOSSY BIT(6) BIT(5) ALL_NON_LOSSY BIT(5) BIT(12) ALL_NON_LOSSY BIT(12) BIT(5) ALL_NON_LOSSY GEOMETRY GEOMETRY ALL_LOSSY BIT(1) BIT(1) ALL_LOSSY DATE DATE ALL_LOSSY ENUM('master',' ENUM('master',' ALL_LOSSY CHAR(10) ENUM('master',' ALL_LOSSY CHAR(10) SET('master','s ALL_LOSSY ENUM('master',' CHAR(10) ALL_LOSSY SET('master','s CHAR(10) ALL_LOSSY SET('master','s SET('master','s ALL_LOSSY SET('master','s SET('master','s ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY TINYINT TINYINT ALL_LOSSY TINYINT SMALLINT ALL_LOSSY TINYINT MEDIUMINT ALL_LOSSY TINYINT INT ALL_LOSSY TINYINT BIGINT ALL_LOSSY SMALLINT TINYINT ALL_LOSSY SMALLINT TINYINT ALL_LOSSY SMALLINT TINYINT UNSIGNE ALL_LOSSY SMALLINT SMALLINT ALL_LOSSY SMALLINT MEDIUMINT ALL_LOSSY SMALLINT INT ALL_LOSSY SMALLINT BIGINT ALL_LOSSY MEDIUMINT TINYINT ALL_LOSSY MEDIUMINT TINYINT ALL_LOSSY MEDIUMINT TINYINT UNSIGNE ALL_LOSSY MEDIUMINT SMALLINT ALL_LOSSY MEDIUMINT MEDIUMINT ALL_LOSSY MEDIUMINT INT ALL_LOSSY MEDIUMINT BIGINT ALL_LOSSY INT TINYINT ALL_LOSSY INT TINYINT ALL_LOSSY INT TINYINT UNSIGNE ALL_LOSSY INT SMALLINT ALL_LOSSY INT MEDIUMINT ALL_LOSSY INT INT ALL_LOSSY INT BIGINT ALL_LOSSY BIGINT TINYINT ALL_LOSSY BIGINT SMALLINT ALL_LOSSY BIGINT MEDIUMINT ALL_LOSSY BIGINT INT ALL_LOSSY BIGINT BIGINT ALL_LOSSY CHAR(20) CHAR(20) ALL_LOSSY CHAR(20) CHAR(30) ALL_LOSSY CHAR(20) CHAR(10) ALL_LOSSY CHAR(20) VARCHAR(20) ALL_LOSSY CHAR(20) VARCHAR(30) ALL_LOSSY CHAR(20) VARCHAR(10) ALL_LOSSY CHAR(20) TINYTEXT ALL_LOSSY CHAR(20) TEXT ALL_LOSSY CHAR(20) MEDIUMTEXT ALL_LOSSY CHAR(20) LONGTEXT ALL_LOSSY VARCHAR(20) VARCHAR(20) ALL_LOSSY VARCHAR(20) VARCHAR(30) ALL_LOSSY VARCHAR(20) VARCHAR(10) ALL_LOSSY VARCHAR(20) CHAR(30) ALL_LOSSY VARCHAR(20) CHAR(10) ALL_LOSSY VARCHAR(20) TINYTEXT ALL_LOSSY VARCHAR(20) TEXT ALL_LOSSY VARCHAR(20) MEDIUMTEXT ALL_LOSSY VARCHAR(20) LONGTEXT ALL_LOSSY VARCHAR(500) VARCHAR(500) ALL_LOSSY VARCHAR(500) VARCHAR(510) ALL_LOSSY VARCHAR(500) VARCHAR(255) ALL_LOSSY VARCHAR(500) TINYTEXT ALL_LOSSY VARCHAR(500) TEXT ALL_LOSSY VARCHAR(500) MEDIUMTEXT ALL_LOSSY VARCHAR(500) LONGTEXT ALL_LOSSY TINYTEXT VARCHAR(500) ALL_LOSSY TEXT VARCHAR(500) ALL_LOSSY MEDIUMTEXT VARCHAR(500) ALL_LOSSY LONGTEXT VARCHAR(500) ALL_LOSSY TINYTEXT CHAR(255) ALL_LOSSY TINYTEXT CHAR(250) ALL_LOSSY TEXT CHAR(255) ALL_LOSSY MEDIUMTEXT CHAR(255) ALL_LOSSY LONGTEXT CHAR(255) ALL_LOSSY TINYTEXT TINYTEXT ALL_LOSSY TINYTEXT TEXT ALL_LOSSY TEXT TINYTEXT ALL_LOSSY DECIMAL(10,5) DECIMAL(10,5) ALL_LOSSY DECIMAL(10,5) DECIMAL(10,6) ALL_LOSSY DECIMAL(10,5) DECIMAL(11,5) ALL_LOSSY DECIMAL(10,5) DECIMAL(11,6) ALL_LOSSY DECIMAL(10,5) DECIMAL(10,4) ALL_LOSSY DECIMAL(10,5) DECIMAL(9,5) ALL_LOSSY DECIMAL(10,5) DECIMAL(9,4) ALL_LOSSY FLOAT DECIMAL(10,5) ALL_LOSSY DOUBLE DECIMAL(10,5) ALL_LOSSY DECIMAL(10,5) FLOAT ALL_LOSSY DECIMAL(10,5) DOUBLE ALL_LOSSY FLOAT FLOAT ALL_LOSSY DOUBLE DOUBLE ALL_LOSSY FLOAT DOUBLE ALL_LOSSY DOUBLE FLOAT ALL_LOSSY BIT(5) BIT(5) ALL_LOSSY BIT(5) BIT(6) ALL_LOSSY BIT(6) BIT(5) ALL_LOSSY BIT(5) BIT(12) ALL_LOSSY BIT(12) BIT(5) ALL_LOSSY GEOMETRY GEOMETRY ALL_LOSSY,ALL_NON_LOSSY BIT(1) BIT(1) ALL_LOSSY,ALL_NON_LOSSY DATE DATE ALL_LOSSY,ALL_NON_LOSSY ENUM('master',' ENUM('master',' ALL_LOSSY,ALL_NON_LOSSY CHAR(10) ENUM('master',' ALL_LOSSY,ALL_NON_LOSSY CHAR(10) SET('master','s ALL_LOSSY,ALL_NON_LOSSY ENUM('master',' CHAR(10) ALL_LOSSY,ALL_NON_LOSSY SET('master','s CHAR(10) ALL_LOSSY,ALL_NON_LOSSY SET('master','s SET('master','s ALL_LOSSY,ALL_NON_LOSSY SET('master','s SET('master','s ALL_LOSSY,ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY TINYINT TINYINT ALL_LOSSY,ALL_NON_LOSSY TINYINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY TINYINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY TINYINT INT ALL_LOSSY,ALL_NON_LOSSY TINYINT BIGINT ALL_LOSSY,ALL_NON_LOSSY SMALLINT TINYINT ALL_LOSSY,ALL_NON_LOSSY SMALLINT TINYINT ALL_LOSSY,ALL_NON_LOSSY SMALLINT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY SMALLINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY SMALLINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY SMALLINT INT ALL_LOSSY,ALL_NON_LOSSY SMALLINT BIGINT ALL_LOSSY,ALL_NON_LOSSY MEDIUMINT TINYINT ALL_LOSSY,ALL_NON_LOSSY MEDIUMINT TINYINT ALL_LOSSY,ALL_NON_LOSSY MEDIUMINT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY MEDIUMINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY MEDIUMINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY MEDIUMINT INT ALL_LOSSY,ALL_NON_LOSSY MEDIUMINT BIGINT ALL_LOSSY,ALL_NON_LOSSY INT TINYINT ALL_LOSSY,ALL_NON_LOSSY INT TINYINT ALL_LOSSY,ALL_NON_LOSSY INT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY INT SMALLINT ALL_LOSSY,ALL_NON_LOSSY INT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY INT INT ALL_LOSSY,ALL_NON_LOSSY INT BIGINT ALL_LOSSY,ALL_NON_LOSSY BIGINT TINYINT ALL_LOSSY,ALL_NON_LOSSY BIGINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY BIGINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY BIGINT INT ALL_LOSSY,ALL_NON_LOSSY BIGINT BIGINT ALL_LOSSY,ALL_NON_LOSSY CHAR(20) CHAR(20) ALL_LOSSY,ALL_NON_LOSSY CHAR(20) CHAR(30) ALL_LOSSY,ALL_NON_LOSSY CHAR(20) CHAR(10) ALL_LOSSY,ALL_NON_LOSSY CHAR(20) VARCHAR(20) ALL_LOSSY,ALL_NON_LOSSY CHAR(20) VARCHAR(30) ALL_LOSSY,ALL_NON_LOSSY CHAR(20) VARCHAR(10) ALL_LOSSY,ALL_NON_LOSSY CHAR(20) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY CHAR(20) TEXT ALL_LOSSY,ALL_NON_LOSSY CHAR(20) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY CHAR(20) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) VARCHAR(20) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) VARCHAR(30) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) VARCHAR(10) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) CHAR(30) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) CHAR(10) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) TEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(20) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(500) VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(500) VARCHAR(510) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(500) VARCHAR(255) ALL_LOSSY,ALL_NON_LOSSY VARCHAR(500) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(500) TEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(500) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY VARCHAR(500) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY TINYTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY TEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY MEDIUMTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY LONGTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY TINYTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY TINYTEXT CHAR(250) ALL_LOSSY,ALL_NON_LOSSY TEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY MEDIUMTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY LONGTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY TINYTEXT TINYTEXT ALL_LOSSY,ALL_NON_LOSSY TINYTEXT TEXT ALL_LOSSY,ALL_NON_LOSSY TEXT TINYTEXT ALL_LOSSY,ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,6) ALL_LOSSY,ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(11,5) ALL_LOSSY,ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(11,6) ALL_LOSSY,ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,4) ALL_LOSSY,ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(9,5) ALL_LOSSY,ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(9,4) ALL_LOSSY,ALL_NON_LOSSY FLOAT DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY DOUBLE DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY