Creating custom DDL datatype mappings?

[Jean Duteau]

I am trying to customize the DDL generation.  I have managed to get the table/column/key definitions to appear mostly the way I want via changing the templates.  The one thing that I can't find is how to specify specific datatype mappings.

As an example, right now, with a default database of Oracle, all string types get converted to VARCHAR(50).  I want to be able to define a few different string types in my model and then have the DDL conversion recognize those types and convert them to different VARCHAR(x).

As well, I want to change the mapping of Boolean to be VARCHAR(1) (don't ask, it's a client thing).

I have looked through the documentation on CONVERT_TYPE but it does not indicate where the mappings are specified and I've had no luck finding them by brute force digging.

[jklap]

What templates are you referring to? I'd like to customize also but can't figure out how to do it

[qwerty]

IIRC the DDL stuff depends on the license and it's not available in all of them. Not sure about that, though.

q.

[jklap]

I've got a Corporate license

[qwerty]

Ah, I was wrong: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1408888579/1#1

q.