Inconsistencies in Field type enumerations are stupid

Discussion created by kimo on May 2, 2010
Latest reply on Jun 21, 2012 by nahmed-esristaff
When I do a Describe on a field in a featureclass to be able to create a foreign key in a new table you would think that the terms would match those required in AddField but they don't and the alternatives are not accepted in the tool.

'SmallInteger' has to change to 'SHORT' and so on.
The only way is to make up a special dictionary as a workaround

eg dFixTypeHack = {'SmallInteger": 'SHORT',..}