I know it's a silly question but is there a way to set the default collation for creating new tables? HeidiSQL correctly shows me what the servers default collation is, but it'd be a nicety to be able to specify what to use as the default in HeidiSQL.
Am I missing an option somewhere or is that just not implemented?