Showing results for 
Search instead for 
Did you mean: 

sap hana function to calculate the string length in bytes

Former Member
0 Kudos

Hello All, i am trying to find a sap hana function to calculate the number of bytes in a string. Well what i exactly need to check if there are any DBCS data in a column. i googled for the issue and found the trick to just compare the number of bytes in a string with number of characters which seems  nice to me to check for any DBCS values. in column but the problem is i cann't find a function which can return me the string length in no of bytes.

can anyone please let me know if there is any function to calculate that or to any alternate way to do what i want !

Thanks for spreading knowledge

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Why don't you convert it into a binary and check the length?