SSC-FDM-0018

CHARACTER SET clause is not supported by Snowflake.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

The column option CHARACTER SET determines the allowed set of characters that can be stored in the column, this clause is not supported by Snowflake.

Code Example

Input Code:

IN -> Greenplum_01.sql

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

Output Code:

OUT -> Greenplum_01.sql

CREATE TABLE TABLE01 (
    COLNAME VARCHAR(20)
--                        --** SSC-FDM-0018 - CHARACTER SET CLAUSE IS NOT SUPPORTED BY SNOWFLAKE. **
--                        CHARACTER SET character_specification
);

Recommendations

• If you need more support, you can email us at [email protected]