MSCEWI4004

Severity

Low

Description

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

Example

Source Code

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

Recommendation

  • No additional user actions 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.