Issue: oracle 9i model: migration script for varchar2 to nvarchar2 is wrong

Hello,

if I change my domain type value from Varchar2 to NVarchar2 I get migration scripts, that conains for every migrated NVarchar2 column a fix length of 30 characters, independent the defined size.

The create scripts is correct only the migration script is wrong.

The result with attached files:
--- SNIP ---
CREATE TABLE "Test_0AAAA4BCFF874BDD8ECD5F3AF"(
"test" NVarchar2(30)
)
...
--- SNAP ---

The create script is okay:
--- SNIP ---
...
CREATE TABLE "Test"(
"test" NVarchar2(1000)
)
...
--- SNAP --

This seems to be a bug.

With regards.

Message was edited by: Berthold

2011-01-26_142059.png

Generated.SQL (248 Bytes)

test-AlterScript.sql (265 Bytes)

test1.txp (26.3 KB)

test2.txp (26.3 KB)

Hi Berthold,

we know about the problem. Next version will contain a fix for this.
Thank you very much for your feedback!

Regards,

Vaclav