Character Set

Character set column definition option

Grammar Syntax

<character string type>  [ CHARACTER SET <character set specification>  ]

Click here to go to the ANSI SQL Standard specification for this syntax.

This clause can be used only when the column is a character string type

This clause is not supported in Snowflake

Sample Source Patterns

ANSI SQL Input Code

CREATE TABLE TABLE01(
    COLNAME VARCHAR(20) CHARACTER SET SOMENAME
);

Snowflake Output Code

CREATE TABLE TABLE01_CHARACTER_STRING_TYPES_CHARACTER_SET (
    COLNAME VARCHAR(20)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. COLUMN CHARACTER SET **
--                        CHARACTER SET SOMENAME
);

Related EWIs

1. MSCEWI1002: Removed next statement, not applicable in SnowFlake