# some server information
show variables like 'char%'
 character_set_client=utf8
 character_set_connection=utf8
 character_set_database=utf8
 character_set_filesystem=binary


# creating the database
create database foo default charset utf8 collate utf8_unicode_ci;

# creating the table
create table bar(
    title varchar(100) collate utf8_bin not null
)engine=myisam charset=utf8 collate=utf8_unicode_ci;