Hi there ,
I have not been able to understand the proper usage of function SUBSTRB .
As in SUBSTRB the arguments m and n are expressed in bytes, rather than in characters , its function is equivalent to SUBSTR if the character set used is ASCII as there each character uses 1 byte only , but if the Character set uset is UNICODE where one character can take up to 3 Bytes , will SUBSTRB function properly , also cant we use SUBSTR in that case to extract the required string. (when database has character set as UNICODE.)
Awaiting reply ,
Thanks.
Udit.
I have not been able to understand the proper usage of function SUBSTRB .
As in SUBSTRB the arguments m and n are expressed in bytes, rather than in characters , its function is equivalent to SUBSTR if the character set used is ASCII as there each character uses 1 byte only , but if the Character set uset is UNICODE where one character can take up to 3 Bytes , will SUBSTRB function properly , also cant we use SUBSTR in that case to extract the required string. (when database has character set as UNICODE.)
Awaiting reply ,
Thanks.
Udit.