DBMS_Metadata Table Comments Unicode

Hi there,

I'm having an issue with PL/SQL Developpper 8 (8.0.0.1480). Im connecting to an Oracle DB with a windows client (NLS_LANG=FRENCH_LUXEMBOURG.WE8MSWIN1252) to an ORACLE 11.2 Database with Character set AL32UTF8. When generating the DDL via DBMS_METADATA on a Table with comments I get this result:

COMMENT ON COLUMN "DWHUSER"."ACTIFNEW"."DEBOCC" IS 'D颵t de l''occupation';

There seems to be a Problem with the UNICODE Implementation, other clients display the output correctly.

Could this be a bug? When disabling Unicode in the properties the comments display correctly.

Cheers,

Alain

 
Back
Top