MSCEWI4004

Collation for values KS, WS is not supported.

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.

  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.