<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://www.ormfoundation.org/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Open Discussion &amp; Feature Requests</title><link>http://www.ormfoundation.org/forums/10.aspx</link><description>This is where you can discuss your suggestions for functions that are not provided by the current release of the NORMA tool. You can also ask questions on how to use the tool.</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator><item><title>Control RDBMS Data Types During DDL Generation</title><link>http://www.ormfoundation.org/forums/thread/2739.aspx</link><pubDate>Wed, 20 Jul 2011 20:59:32 GMT</pubDate><guid isPermaLink="false">9d039735-a311-4a8d-9c49-a0bb2572af9e:2739</guid><dc:creator>ronmwhite</dc:creator><slash:comments>0</slash:comments><comments>http://www.ormfoundation.org/forums/thread/2739.aspx</comments><wfw:commentRss>http://www.ormfoundation.org/forums/commentrss.aspx?SectionID=10&amp;PostID=2739</wfw:commentRss><description>Note that I am placing this post here for future reference as this is a FAQ that I do not see addressed in the current NORMA documentation stack.

To change the default data types specific to your RDBMS you need to modify the XLST Stylesheet that is used during the generation process. At the time of this writing, that can be found in the following location (WinXP): &amp;quot;C:\Program Files\Common Files\Neumont\DIL\Transforms&amp;quot;.

Pick the Stylesheet of interestes, e.g., DDILtoOracle.xslt, and edit accordingly. For exmaple, if you want all BOOLEAN types in Oracles to render as &amp;quot;CHAR(1)&amp;quot;, you would navigate to the entry for the BOOLEAN type and make the corresponding change from the default of &amp;quot;NCAHR(1)&amp;quot;.</description></item></channel></rss>