When converting a feature class from PGDB to SDE, a field type Float converts to a Double with extra values.
上次发布: August 25, 2014No Product Found
漏洞 ID 编号
NIM010927
已提交
August 13, 2007
上次修改时间
April 28, 2025
适用范围
No Product Found
找到的版本
9.2
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
No Public Explanation
解决办法
1. Create an empty feature class in SDE geodatabase with same spatial reference as that of the PGDB feature class.2. While creating, Import the fields from the PGDB feature class.3. For Float fields, choose precision and scale as per the requirement (say, precision-5, scale-2)4. Click “Finish” to create the feature class.5. Check again by right clicking the feature class that the Float fields are maintained.6. Now, load the data into this feature class from the PGDB feature class by simple data loader in ArcCatalog. Right click on the feature class? Load Data7. This method retains the original names of the fields.Per Nana Dei:For SQL Server: When the column is created with the ‘REAL’ data type, it shows as Float from ArcCatalogHowever, when it is created as ‘Float’ from ArcCatalog is shows as DOUBLE in ArcCatalog 10 and NUMERIC in SQL Server.