drop table if exists binary_cast_insert;

create table binary_cast_insert (b binary);

insert into table binary_cast_insert values (cast("a" as binary));
insert into table binary_cast_insert values (cast("hello" as binary));
insert into table binary_cast_insert values (cast(cast("hello" as char(10)) as binary));
insert into table binary_cast_insert values (cast(cast("hello" as varchar(10)) as binary));

select * from binary_cast_insert;