mysql> DROP TABLE IF EXISTS t1;

Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE t1 (a VARCHAR(1)) CHARACTER SET latin2 COLLATE latin2_czech_cs;

Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO t1 VALUES (0xF3),(0xD3);

Query OK, 2 rows affected (0.00 sec)

Records: 2  Duplicates: 0  Warnings: 0

mysql> DROP TABLE IF EXISTS t2;

Query OK, 0 rows affected (0.11 sec)

mysql> CREATE TABLE t2 AS SELECT weight_string(a) FROM t1;

Query OK, 2 rows affected, 2 warnings (0.36 sec)

Records: 2  Duplicates: 0  Warnings: 2

mysql> SHOW WARNINGS;

+---------+------+-------------------------------------------------------+

| Level   | Code | Message                                               |

+---------+------+-------------------------------------------------------+

| Warning | 1265 | Data truncated for column 'weight_string(a)' at row 1 |

| Warning | 1265 | Data truncated for column 'weight_string(a)' at row 2 |

+---------+------+-------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> SHOW CREATE TABLE t2;

+-------+-----------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                              |

+-------+-----------------------------------------------------------------------------------------------------------+

| t2    | CREATE TABLE `t2` (

  `weight_string(a)` varbinary(1) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+-----------------------------------------------------------------------------------------------------------+

1 row in set (0.16 sec)

mysql> SELECT LENGTH(weight_string(a)) FROM t1;

+--------------------------+

| LENGTH(weight_string(a)) |

+--------------------------+

|                        8 |

|                        8 |

+--------------------------+

2 rows in set (0.00 sec)