MSCEWI2031
The result may differ due to char type having a fixed length in Teradata
Last updated
The result may differ due to char type having a fixed length in Teradata
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
Since Teradata CHAR data type has a fixed length, some functions such as REGEXP_SIMILAR and LIKE will try to match the complete column instead of the word inserted into the column, resulting in false matches. However, Snowflake the CHAR type is of variable size, meaning that the REGEXP_LIKE and LIKE functions will always try to match against the inserted values. Take the following code as an example:
Analyze the use given to the function results, maybe the Snowflake REGEXP_LIKE function behavior was the one desired from the start and no changes are required.
If you need more support, you can email us at