雪花中的varchar(n)是什么意思？

Question

我在雪花中有一个列，里面有我给它的大URL，varchar( 50 )是否意味着它只能存储50个字符？

谢了，习

Answer 1

( 50 )是否意味着它只能存储50个字符？

是。

CREATE OR REPLACE TABLE t(col VARCHAR(50));

INSERT INTO t(col) SELECT REPEAT('a', 51);
-- String 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long
-- and would be truncated


SELECT CAST(REPEAT('a', 51) AS VARCHAR(50));
-- String 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long
-- and would be truncated