MSCEWI2018

Variant column does not support collation.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This message is shown when SnowConvert a Variant data type in the transformation of a code has a COLLATE clause. Since COLLATE is not supported with the data type VARIANT, it will be removed and a message will be added.

Code Example

Input Code:

CREATE TABLE TableExample
(
ColumnExample JSON(2500) NOT CASESPECIFIC
)

Output Code:

CREATE TABLE PUBLIC.TableExample
(
ColumnExample VARIANT /*** MSC-WARNING - MSCEWI2018 - VARIANT COLUMN DOES NOT SUPPORT COLLATION ***/
);

The data type JSON is converted to VARIANT, while NOT CASESPECIFIC is converted to a COLLATE clause.

Because if this scenario, since VARIANT does not support COLLATE, it is removed.

Recommendations

• No additional user actions are required.

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