Create Table Charset

Good day,

How can I specify a UTF-8 charset when creating a MySQL table?

CHARSET=UTF8

http://dev.mysql.com/doc/refman/5.1/en/create-table.html

Thank you very much.
Can you show me an example maybe?
Is the below correct?..

CREATE TABLE `table_name` (`field_name` VARCHAR(100) NOT NULL DEFAULT 'default') ENGINE=MyISAM AUTO _INCREMENT=1 CHARSET=UTF8

Shouldn’t it be CHARACTER SET=UTF8 ? Or is CHARSET=UTF8 correct?
What about collation? Do I just append it to the query, for example…

COLLATE=UTF8_bin

Looks fine to me. Did you try?
I would get rid of that space between AUTO and _INCREMENT :slight_smile:

What about collation? Do I just append it to the query, for example…

COLLATE=UTF8_bin

I’ve got no idea.