MSC-PG0002
Bpchar converted to varchar
Last updated
Bpchar converted to varchar
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
This warning is added because bpchar type (“blank-padded char”) may have some functional equivalence difference compared to the varchar data type in Snowflake. However, both data types can store the values up to the “n” length of characters and consume storage for only the amount of actual data stored. The main difference occurs when there are blanks at the end of the data, where bpchar does not store them but snowflake does.
For this reason, we can use the RTRIM function so that these blanks are not stored. But there may be cases where the functionality is not completely equivalent.
The rtrim
function can resolve storage differences in case you want those blanks not to be stored. This case is handled in the , however, there may be other scenarios where it has to be handled manually. For more information refer to the Snowflake documentation about .
If you need more support, you can email us at