Just one more update. We have TD14 and TD 15 on different servers and I did following query
select case when regexp_similar('¥','^.$', 'i')=1
end as output;
In case of TD 14, I get output as 'N' and in case of TD 15 answer is 'Y'. This is more intruiging now.
I thank Dnoeth for all his suggestions