Toad World® Forums

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


#1

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)


#2

Hi Berthold,

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

Regards,

Vaclav