DEF OF COLLATE CODE

Using the Column.Collation property in SQL Server Management Objects (SMO). For more information, see Modify Columns (Database Engine). This method is much faster than in-place conversion, but handling complex schemas with many dependencies (FKs, PKs, Triggers, DFs) and syncing the tail of the table (if the database is in use) requires more planning.įor more information, see Collation and Unicode Support. To convert the column to use UTF-8, copy the data to a new table where the target column is already the required data type and a UTF-8 enabled collation, and then replace the old table: CREATE TABLE dbo.MyTableNew (CharCol VARCHAR(50) COLLATE Latin1_General_100_CI_AI_SC_UTF8) ĮXEC sp_rename 'dbo.MyTableNew', 'dbo.MyTable'

DEF OF COLLATE CODE

VARCHAR column is encoded using the Latin code page and therefore is not Unicode capable Consider one of the existing tables defined below: - NVARCHAR column is encoded in UTF-16 because a supplementary character enabled collation is used This method is easy to implement, however it's a possibly blocking operation which may become an issue for large tables and busy applications.Ĭopy and replace.

To convert the column in-place to use UTF-8, run an ALTER COLUMN statement that sets the required data type and a UTF-8 enabled collation: ALTER TABLE dbo.MyTableĪLTER COLUMN CharCol VARCHAR(50) COLLATE Latin1_General_100_CI_AI_SC_UTF8 VARCHAR column is encoded the Latin code page and therefore is not Unicode capableĬREATE TABLE dbo.MyTable (CharCol VARCHAR(50) COLLATE Latin1_General_100_CI_AI) Consider one of the existing tables defined below: - NVARCHAR column is encoded in UTF-16 because a supplementary character enabled collation is usedĬREATE TABLE dbo.MyTable (CharCol NVARCHAR(50) COLLATE Latin1_General_100_CI_AI_SC) The COLLATE clause of CREATE TABLE and ALTER TABLE, as seen in the examples below. You can override the database collation for char, varchar, text, nchar, nvarchar, and ntext data by specifying a different collation for a specific column of a table and using one of the following:

Def of collate