Which statement about VARCHAR synonyms in Snowflake is correct?

• A. VARCHAR synonyms include STRING, TEXT, NVARCHAR, CHAR, and CHARACTER
• B. VARCHAR synonyms include BLOB
• C. VARCHAR synonyms include NUMBER
• D. VARCHAR synonyms do not exist

Answer: (A)

Snowflake treats the string type family as flexible naming for the same underlying data type. VARCHAR is the variable-length string type, and Snowflake maps several other names to that same type: STRING, TEXT, NVARCHAR, CHAR, and CHARACTER. That means you can declare, compare, and cast using any of these aliases and get identical behavior and storage characteristics. This helps when porting code from different SQL dialects that prefer different type names. The other options aren’t fitting because they refer to non-string types (BLOB, NUMBER), and it’s not true that no synonyms exist—the platform does support these alias names for VARCHAR.