'equivalent for "COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL" in snowflake

SQL Server:

CREATE TABLE outpatients (
    lastupdatedby nvarchar(250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    quote_id decimal(11,0) NULL,
    customersite_ID decimal(11,0) NULL)

What's the equivalent for COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL in snowflake?

sqlsnowflake-cloud-data-platformcollate


Solution 1:[1]

it would seem you want ether COLLATE 'en_ci_as' or COLLATE 'ci_as' as the code page and latin1 parts do not appear to apply.

Solution 2:[2]

Latin-1 is basically extended ASCII, according to https://kb.iu.edu/d/aepu.

I don't think you will get the exact same collation in Snowflake, but en-ci-as could be the closest one.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Eric Lin

Related Questions