It shouldn't. This only define the default charset/collation in case we don't specify it.
As we now define it both for CREATE TABLE and CREATE TEMPORARY, I can't think of a missing case, but I'm not a dba either ;)