Skip to Content
0
Former Member
Mar 17, 2015 at 07:15 AM

sap hana function to calculate the string length in bytes

372 Views


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 😀