# Option to change datatype from Char(n) to VarChar2(n) when generating DDL

**URL:** <https://forums.toadworld.com/t/option-to-change-datatype-from-char-n-to-varchar2-n-when-generating-ddl/1921>\
**Category:** Toad Data Modeler\
**Created:** [March 16, 2009, 7:07pm UTC](https://forums.toadworld.com/t/option-to-change-datatype-from-char-n-to-varchar2-n-when-generating-ddl/1921 "2009-03-16T19:07:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![YewWee](https://avatars.discourse-cdn.com/v4/letter/y/f0a364/32.png) [@YewWee](https://forums.toadworld.com/u/YewWee)\
**Post date:** [March 16, 2009, 7:07pm UTC](https://forums.toadworld.com/t/option-to-change-datatype-from-char-n-to-varchar2-n-when-generating-ddl/1921/1 "2009-03-16T19:07:47Z")

</div>

Hi,

Is there an existing Enhancement Request for this issue?

Option to change datatype from Char(n) to VarChar2(n) when generating DDL Script.

eg.

–THIS IS WHAT I GET:

CREATE TABLE race\_meet\_pools\_f(  
race\_type\_id Char(2 BYTE),  
DATE\_ID Integer,  
provider\_id Char(3 BYTE),  
course\_locn\_id Integer,  
DD Number(15,2),  
QD Number(15,2),  
TT Number(15,2),

–THIS IS WHAT I WANT:

CREATE TABLE race\_meet\_pools\_f(  
race\_type\_id VarChar2(2),  
DATE\_ID Integer,  
provider\_id VarChar2(3),  
course\_locn\_id Integer,  
DD Number(15,2),  
QD Number(15,2),  
TT Number(15,2),

Regards,  
Yew Wee

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [March 17, 2009, 6:15am UTC](https://forums.toadworld.com/t/option-to-change-datatype-from-char-n-to-varchar2-n-when-generating-ddl/1921/2 "2009-03-17T06:15:28Z")

</div>

Hello Yew,

Please find attached a script that will go through all attributes and change every Char data type (without specification if the length is in BYTE or CHAR) to Varchar2.  
Example: Char(20 BYTE) will be changed to Varchar2(20).  
The script works for all supported Oracle versions.

Please execute the script in Scripting Window (Tools menu, Expert mode has to be on - Settings | Options | General | Expert Mode checkbox).

If you have any questions, please write us back. Thanks.

Regards,

Vladka + TDM Team  
[DatatypeChange.js](https://global.discourse-cdn.com/quest/original/2X/7/709037c55eccb3038d6499fd0613df23c0fcabd2.js) (1.08 KB)

---

<div class="post-metadata">

**Author:** ![joel.zwinger\_734](https://avatars.discourse-cdn.com/v4/letter/j/b782af/32.png) [@joel.zwinger\_734](https://forums.toadworld.com/u/joel.zwinger_734)\
**Post date:** [January 3, 2012, 6:20pm UTC](https://forums.toadworld.com/t/option-to-change-datatype-from-char-n-to-varchar2-n-when-generating-ddl/1921/3 "2012-01-03T18:20:26Z")

</div>

Not a jscript scriptor. Code does not seem to work for version 4. I think I have the correct app object number?

I was trying to create an automation script where varchar \< 255 set it to 255. Where greater than 255 then set to max.

Also trying to change all numerics to (38,2) unless there is a scale of 0 then I just want to convert them to an integer

---

<div class="post-metadata">

**Author:** ![Vaclav\_Frolik](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vaclav_frolik/32/12_2.png) [@Vaclav\_Frolik](https://forums.toadworld.com/u/Vaclav_Frolik)\
**Post date:** [January 4, 2012, 4:07am UTC](https://forums.toadworld.com/t/option-to-change-datatype-from-char-n-to-varchar2-n-when-generating-ddl/1921/4 "2012-01-04T04:07:30Z")

</div>

Hi,

the script works in version 4.x  
Please make sure you work with the right model. The following article explains how to use scripting window:

[http://blogs.inside.quest.com/modeling/2012/01/04/scripting-window-tdm/](http://blogs.inside.quest.com/modeling/2012/01/04/scripting-window-tdm/)

Information about objects and properties can be found in Reference, incl. information about data types.

Regards,

Vaclav

 ![ref-guide.png](https://global.discourse-cdn.com/quest/original/2X/e/e4736d437ac6d187d1c719b15d198d92cf639123.png)
