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.