missed a truncate, tests pass now
drop collation statements in create, drop charset in create where not text