SQL & PL/SQL

Hi guys,

Today I tried with SQL function 'unistr', found it strange in the parameter...

My environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE    11.2.0.2.0    Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production

and

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

"CORE    11.2.0.3.0    Production"

TNS for Solaris: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

client is PL/SQL Developer 7.1.4.1390

As documented, I tried with a Unicode encoding value, but got blank (not a NULL):

SELECT unistr('\00f6') FROM dual;

but when I tried a value with some character appended, it worked:

SELECT unistr('\00f6 ') FROM dual;

ö

SELECT unistr('\00f6a') FROM dual;

ö

SELECT unistr('\00f6*') FROM dual;

ö

Is it caused by the client, anyone helps?