MSCEWI4004

Collation for values KS, WS is not supported.

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

Severity

Low

Description

This warning is added when there is a collate clause, and some of its specifications are not supported in Snowflake.

Code Example

Input Code:

SELECT 'a' COLLATE Latin1_General_CI_AS_KS_WS;

Output Code:

SELECT 'a' COLLATE 'EN-CI-AS' /*** MSC-WARNING - MSCEWI4004 - COLLATION FOR VALUES KS,WS NOT SUPPORTED ***/;

Recommendations

• No additional user actions are required.

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