Generate DDL (Oracle).

[Victor Conovalov]

Hello All,
In fact, when you specify the length for Oracle varchar2 data type column, by default it is length in bytes.
But, you have option to add keyword “char” after the length, and Oracle interpreters it as a char and allocate the size according NLS parameters.
For example take a look on http://www.oracle-base.com/articles/9i/CharacterSemanticsAndGlobalization9i.php
I have use EA for designing my Physical model (tables) and after any changes generate DDL for all tables from EA. Un-fortunally, I did not find the way how to specify the CHAR keyword for varchar2 column and do not want to manually edit the output sql files from EA.
Is exist any way how to add CHAR keyword after the length of varchar2 column when EA generating the sql file?

[hd]

See...
http://www.sparxsystems.com/uml_tool_guide/data_modeling/createcolumns.html

Create the column and save. Select the column and click Column Properties... to set LengthType.

[Victor Conovalov]

My EAP version is: 7.1.832 (Build: 832) - Unicode
I have add LengthType tag = CHAR to my table tags.
I have choose Oracle on Table Properties->Database
When click on Column Properties see jut three fields:
Check Box: Auto Number
Text edit: Start Value
Text Edit: Increment.
When generate the DDL, varchar2 columns appear without the CHAR keyword.

[hd]

If you are unable to upgrade to the latest build, the link in my previous post provides a work around in the Notes of Item 5...

Oracle VARCHAR2(15 CHAR) and VARCHAR2(50 BYTE) datatypes can be created by adding the tag LengthType with the value CHAR or BYTE.