I have an existing feature class in an enterprise geodatabase with a float field. I would like to add a coded domain to limit the options a user has when performing data entry. Specifically, I want a coded domain so that the users will see 4.3 m (14ft) in the dropdown and 4.3 will be applied to the field as a value.
When I set up the domain I choose field type Float and set my codes and descriptions without any problems, click Apply, OK, I'm happy. When I try to go back into Database Properties a moment later (without applying the domain to any fields) the Field type has now changed to Double. When I try to change it back to Float I get an error "The existing domain field type does not match that of the updated domain".
Side note: I have followed the steps above and was able to successfully apply a domain to a float field in a file geodatabase.
Can anyone help me out? Is this a limitation of an enterprise gdb?