MSCEWI3091
LENGTHB transformed to OCTET_LENGTH results may vary due to memory management of DBMS
Last updated
LENGTHB transformed to OCTET_LENGTH results may vary due to memory management of DBMS
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
This issue happens when there is an invocation to function that returns the size of a column or literal in bytes. This function is transformed into Snowflake's function.
When the parameter to the function is a column, the result will be the size of the value that the column has, this size may vary from Oracle to Snowflake, the type of the column plays an important role in the result returned by the function.
Manually check the data types used.
Check the encoding of the columns used because OCTET_LENGTH can return bigger sizes when the string contains Unicode code points.
If you need more support, you can email us at