Every table has a table character set and a table collation. The COLLATE clause assigns a collation to the column (which must be of a collatable data type). The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name] If not specified, the column data type's default collation is used. CREATE TABLE t1 ( c1 varchar(20) COLLATE Divehi_90_CI_AS_KS_WS) WITH (PARTITION (c1 RANGE FOR VALUES (N''))) If boundary_value is a literal value that must be implicitly converted to the data type in partition_column_name , a discrepancy will occur.

This enables the temporary table to work with similarly formatted tables in multiple databases, if that is required of your system. 次の例で示すような、CREATE TABLE と ALTER TABLE の COLLATE 句。 The COLLATE clause of CREATE TABLE and ALTER TABLE, as seen in the examples below. 以下に定義されている既存のテーブルのいずれかについて検討してください。 The table will be owned by the user issuing the command. Specify that the temporary table column use the default collation of the user database, not tempdb. CREATE TABLE will create a new, initially empty table in the current database.

You can override the table’s default collation and assign a data-bound collation to a particular column by specifying the COLLATE clause in the column_definition or virtual_column_definition clause of CREATE TABLE or ALTER TABLE, or the modify_col_properties or … CREATE TABLE #TestTempTab (PrimaryKey int PRIMARY KEY, Col1 nchar COLLATE database_default ); インプレース変換。 In-place conversion.