0

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?

Charlieface
  • 52,284
  • 6
  • 19
  • 43
Madhu Pasham
  • 21
  • 5

2 Answers2

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.

Simeon Pilgrim
  • 22,906
  • 3
  • 32
  • 45
0

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.

Eric Lin
  • 1,440
  • 6
  • 9