compare table data - no ascii characters

[Kajman]

Hello,

after move to windows 10, i have a problem with Compare table data. If any generated sql command included no ascii chars then sql commands for whole table are ommited in Differences tab.

In Developer window i see this only

rem Differences between <CURRENT USER>@SERVER1 and KAJMAN@SERVER2, created on 20.01.2017
rem Press Apply button, or run in Command Window or SQL*Plus connected as KAJMAN@SERVER2

-- TABLE KAJ_TMP
-- Deleting ...
-- Updating ...
-- Inserting ...
-- 2 row(s) total
-- 2 row(s) read
-- 0 row(s) deleted
-- 2 row(s) inserted
-- 0 row(s) updated

-- TABLE KAJ_TMP2
-- Deleting ...
-- Updating ...
-- Inserting ...
-- 2 row(s) total
-- 2 row(s) read
-- 0 row(s) deleted
-- 2 row(s) inserted
-- 0 row(s) updated

INSERT INTO KAJ_TMP2 T (ID, TEXT)
  VALUES (1, 'a');
INSERT INTO KAJ_TMP2 T (ID, TEXT)
  VALUES (2, 'b');
COMMIT;

But in tmp file Compare.sql is

-- TABLE KAJ_TMP
-- Deleting ...
-- Updating ...
-- Inserting ...
-- 2 row(s) total
-- 2 row(s) read
-- 0 row(s) deleted
-- 2 row(s) inserted
-- 0 row(s) updated

d>zINSERT INTO KAJ_TMP T (ID, TEXT)
  VALUES (1, 'a`');
INSERT INTO KAJ_TMP T (ID, TEXT)
  VALUES (2, 'b');
COMMIT;

-- TABLE KAJ_TMP2
-- Deleting ...
-- Updating ...
-- Inserting ...
-- 2 row(s) total
-- 2 row(s) read
-- 0 row(s) deleted
-- 2 row(s) inserted
-- 0 row(s) updated

d>zINSERT INTO KAJ_TMP2 T (ID, TEXT)
  VALUES (1, 'a');
INSERT INTO KAJ_TMP2 T (ID, TEXT)
  VALUES (2, 'b');
COMMIT;

Bytes of "d>z" in hex are - ef bb bf

Byte of "a`" is - e1

PL/SQL Developer
  Version 11.0.6.1796  (64 bit)
  Windows 10 Build 14393

Character Sets
  Character size: 4 byte(s)
  CharSetID: 873
  NCharSetID: 2000
  Unicode Support: True
  NLS_LANG: CZECH_CZECH REPUBLIC.EE8MSWIN1250
  NLS_CHARACTERSET: AL32UTF8
  NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Marco Kalter]

It seems like the database has a UTF8 character set, so the character data in the .sql file should be encoded as Unicode. Which tool did you use to view the .sql file? Can you send it to me by e-mail?

 

[Kajman]

After change client NLS_LANG (in registry HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home2) from EE8MSWIN1250 to AL32UTF8 it works fine.

But I have two little wishes:

If I manually edit the SQL text in the tab Differences, the program can ask me whether to apply original or modified text? Always apply the original.

I would welcome a quick jumping in the tab Selection through writing the beginning of the table name.

Thanks.

 

[Marco Kalter]

I have added this to the list of enhancement requests.