set names utf8;
CREATE DATABASE db_types;
USE db_types;

CREATE TABLE all_types ( 
   v_bigint    bigint,
   v_varchar   VARCHAR(99) character set utf8,
   v_bit       bit,
   v_longtext  longtext character SET utf8,
   v_longblob  longblob ,
   v_numeric   numeric(16,4)
);

INSERT all_types ( v_bigint, v_varchar, v_bit, v_longtext, v_numeric ) VALUES ( 1010101, 'this is a varchar', 1, 'long test', '11111.5678' );

COMMIT;