This is indeed a character set roblem. The problem only occurs with Umlauts in comments.
My DB is configured using UTF8:
select * from nls_database_parameters
where parameter in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET'):
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8
My NLS_LANG...
Here it comes:
Oracle 9.2.0.5.0
PL/SQL Developer 7.0.3.1123
Two identical DDLs in both schemas:
-- Create table
create table WFL01_WORKFLOW
(
ID NUMBER(19) not null,
OBJECTVERSION NUMBER(10) not null,
ENTITY NUMBER(19) not null,
TOPIC NUMBER(10)
)
tablespace...
Comparing two identical tables with column comments produces difference to add column comment which is already there:
comment on column XYZ.abc is 'text...';
This sound like a bug to me.
Could this be fixed.
Thanks.
Regards,
Gerald