also you can encode your table right before creating the table that saves so much extra effort
CREATE DATABASE my_database WITH ENCODING 'UTF8'