SQL & PL/SQL

Hi All,

Recently, I did one SQL statement as following:

SQL> select CONVERT(DESCRIPTION,'UTF8','WE8ISO8859P1')
from test
where siteid=114 and descid=1277;
ERROR:
ORA-01482: unsupported character set

DESCRIPTION is a CLOB type column. My Oracle version is 9.2.0.4, OS is Linux AS 3.

When I took out the second parameter of convert() function -- 'WE8ISO8859P1', it could work well.

I want to know whether this is a bug of Oracle? How can I resolve it?

Best Regards
-Doris