We were using length and lengthB function in 10g. In below given statement E is Greek character. Below RPAD is returning different result on 10g and 11g which gives error of size.
10g = RPAD (trim('E'),(lengthb(trim('E'))-length(trim('E')))+4, '-') as rpadstr = 4
11g = RPAD (trim('E'),(lengthb(trim('E'))-length(trim('E')))+4, '-') as rpadstr = 5
On 10g
lengthb(trim('E') = 2
lengthb(trim('E') = 1
On 11g
lengthb(trim('E') = 2
lengthb(trim('E') = 1
Can you please help to return same result as 10G?
Thanks in advance.