Why are VARCHAR lengths from Snowflake tripled in SAS DI Studio?

[jozumfoen]

Hi everyone,

I’m accessing Snowflake tables through SAS Data Integration Studio using the Snowflake connector.

When I register  table from Snowflake in SAS DI, I noticed that VARCHAR(n) columns are automatically assigned LENGTH=3n in SAS metadata.
For example: VARCHAR(2) becomes LENGTH=6.

Why does this happen, even though both systems use UTF-8?

Thanks in advance!

[Kurt_Bremser]

My first idea would be that Snowflake counts UTF characters, while SAS counts bytes.

[SASKiwi]

We use SAS/ACCESS Interface to Snowflake too and see the same behaviour.

A Google search suggests that this could be standard Snowflake behaviour: https://community.snowflake.com/s/article/Varchar-length-implicitly-increases-if-column-is-Uppercase...

[jozumfoen]

Hi everyone,

I’m accessing Snowflake tables through SAS Data Integration Studio using the Snowflake connector.

When I register  table from Snowflake in SAS DI, I noticed that VARCHAR(n) columns are automatically assigned LENGTH=3n in SAS metadata.
For example: VARCHAR(2) becomes LENGTH=6. Why does this happen, even though both systems use UTF-8?

Thanks in advance!

[Patrick]

It's certainly worth to look into options DBCLIENT_MAX_BYTES and DBSERVER_MAX_BYTES