You can set a character set both per table, as well as per individual field using the CHARACTER SET and CHARSET statements:
CREATE TABLE Address (
`AddressID` INTEGER NOT NULL PRIMARY KEY,
`Street` VARCHAR(80) CHARACTER SET ASCII,
`City` VARCHAR(80),
`Country` ...