database - mySQL VARCHAR(256) + mySQL INT = how many bytes? -

database - mySQL VARCHAR(256) + mySQL INT = how many bytes? -

create schema if not exists `utftest` default character set utf16; create table if not exists `metadata_labels` (`metadata_id` int not null , `label` varchar(256) not null , primary key (`metadata_id`, `label`));

however next error msg:

specified key long; max key length 767 bytes

please advise

utf 16 uses 32 bits per character (4 bytes) in mysql. 4 x 256 > 767.

if possible, recommend using other utf16 varchar key.

mysql database int varchar utf-16