louchios

Appending data from Double field to SDE changes the precision and scale in SDE

Discussion created by louchios on Jan 29, 2014
Hi I just created a new feature class in SDE with Short integers, text, and two double fields.

I set the double field to have scale: 7, precision: 2.

After I run my python script to append the data for the first time, the two double fields in SDE now have scale: 38, precision: 8. Why is this happening? Every other field is fine. The data in the two double fields only contain 2 decimal places and the the values are all small ranging from 0.00 to 12.95. We use SQL Server 2008.

Thank you for any help.

Outcomes