Compare objects produces unnecessary column comment statement

[Gerald Glocker]

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

 

[Marco Kalter]

I can't reproduce this. Are you sure there is no difference? If so, can you let me know your PL/SQL Developer version and the table creation DDL?

 

[Gerald Glocker]

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 MDS_BIG
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column WFL01_WORKFLOW.ID
is 'Eindeutige Id';
comment on column WFL01_WORKFLOW.ENTITY
is 'Verweis auf Workflow-Gesch

 

[Marco Kalter]

This works fine for me. Perhaps the problem is caused by the umlaut in Gesch

 

[Gerald Glocker]

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 settings for PL/SQL-Developer are:
NLS_LANG=German_Germany.WE8MSWIN1252

I tried different NLS_LANG settings with no success.

Is there a problem in PL/SQL-Developer with Umlauts in the comparison?

 

[Marco Kalter]

Can you go to Tools > Preferences > Oracle / Options, disable the "Unicode enabled" option, and try again?

 

[Gerald Glocker]

Yes - this works.
But shouldn't "Unicode" be enabled?

By the way - this option is not documentent in the online help.

Thanks,
Gerald

 

[Marco Kalter]

Unicode only needs to be enabled if you are actually using Unicode characters outside of (in your case) WE8MSWIN1252.

We'll look into the problem.