laptop and a wrench

Bug

The shp2sde and tbl2sde commands need to support UNICODE n-string data to allow the proper importing of data that contains non-English characters.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM013560
SubmittedDecember 10, 2007
Last ModifiedApril 16, 2025
Applies toNo Product Found
Version found9.3
Version Fixed9.3
StatusFixed

Workaround

This bug is being fixed but need to use a conversion file to load.For example:To import foreign character shapefile correctly using shp2sde command, you will need to use a conversion file and convert the column type as nstring.For example, in the Russian shapefile, you have several columns contained Russian characters.To create an conversion file, use notepad and write the following line in the file:<shpCol> [sdeCol] [type] [size] [nDecs] [NOT_NULL]If the first field called "Fullname" contain Russian, then specify the following line in the conversion text file:FULLNAME FULLNAME nstring 100Then save this file as conversion.txt.Now you will use the following syntax to load this shapefile:shp2sde -o create -u map -p map -l Russian,shape -f <a href="file:C:/temp/russian.shp" target="_blank">C:\temp\russian.shp</a> -a file=<a href="file:C:/temp/conversion.txt" target="_blank">C:\temp\conversion.txt</a> -i 5151Added on 08/14/08 by Shwu-Jing Jeng

Steps to Reproduce

Bug ID: NIM013560

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options