created tables and handled character set