How does one set the default character set for fields when creating tables in SQL Server? In MySQL one does this:
CREATE TABLE tableName (
name VARCHAR(128) CHARACTER SET utf8
) DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Note that I set the character set twice here. It is redundant, I added both ways just to demonstrate.
I set the collation also to demonstrate that collation is something different. I am not asking about setting the collation. Most questions asking about character sets and encodings in SQL Server are answered with collation, which is not the same thing.
As stated in BOL
The quote above is from 2000 docs. See also this 2008 link. The below also demonstrates this.
Results