1
General Board / Re: DDL transformation datatypes
« on: February 13, 2007, 12:04:20 am »
Hi,
I don't understand.
If I set a class attribute type to string and add a string ->varchar mapping to SQL200 database and set this database as the default, the type gets transformed to text.
If I set the class attribute type to mystring and map mystring->varchar then the type gets tranformed to varchar.
The transfromation template for attribute contains:-
type=%qt%%CONVERT_TYPE(genOptDefaultDatabase,attType)%%qt%
I understand this to mean: lookup the class attribute type as commontype in the datatype/commontype mapping list for the default database and transform commontype to datatype if the mapping exists.
I don't know what I need to change to get string transformed to varchar.
Thanks,
I don't understand.
If I set a class attribute type to string and add a string ->varchar mapping to SQL200 database and set this database as the default, the type gets transformed to text.
If I set the class attribute type to mystring and map mystring->varchar then the type gets tranformed to varchar.
The transfromation template for attribute contains:-
type=%qt%%CONVERT_TYPE(genOptDefaultDatabase,attType)%%qt%
I understand this to mean: lookup the class attribute type as commontype in the datatype/commontype mapping list for the default database and transform commontype to datatype if the mapping exists.
I don't know what I need to change to get string transformed to varchar.
Thanks,