topic Re: ArcSDE 10 shp2sde - Unicode characters fail even with a definition file in Data Management Questions

ArcSDE 10 shp2sde - Unicode characters fail even with a definition file

KaanYanç — Fri, 18 Feb 2011 13:53:05 GMT

Greetings,

I am trying to import shapefiles with unicode codepages set, into an ArcSDE 10 installed Oracle 11g (charset AL32UTF8) via using shp2sde tool.

I can successfully import the shapefile however, i fail with the character encoding.

Below is the command i use and the output generated.

$ shp2sde -o create -l sp_polygon_adminbndy,shape -f adminbndy -a file='adminbndy.def' -u <SDEUSER> -p <SDEPASS>

[INDENT]ArcSDE 10.0 for Oracle11g Build 685 Fri May 14 12:05:43 2010
Shape to Layer Loading   Administration Utility
-----------------------------------------------------
Change POLYGON_NM col_def from SE_STRING,105,0
                          to   SE_NSTRING,105,0
Set X_offset   =          25
Set Y_offset   =          39
Set XY_scale   =900000000000000
Set Grid Size0 =           1
23         features converted.
23         features stored.[/INDENT]

Below is my one line definition file;

[INDENT]POLYGON_NM POLYGON_NM NSTRING 105 0[/INDENT]

Below is how a couple record should have seen and how do they seen after import.

[INDENT]KIRKLARELİ SDE.ST_GEOMETRY(...)
�?ANAKKALE SDE.ST_GEOMETRY(...)[/INDENT]

[INDENT]KIRKLAREL�?° SDE.ST_GEOMETRY(...)
�?�?ANAKKALE SDE.ST_GEOMETRY(...)[/INDENT]

Any help will be much appreciated, thanks.

Re: ArcSDE 10 shp2sde - Unicode characters fail even with a definition file

KristofVydt — Mon, 25 Jul 2011 06:57:48 GMT

I'm not sure if this helps ...

"Can UTF-8 shapefiles be imported into or exported from an ArcSDE geodatabase?"
http://support.esri.com/en/knowledgebase/techarticles/detail/31834

Re: ArcSDE 10 shp2sde - Unicode characters fail even with a definition file

VinceAngelo — Mon, 25 Jul 2011 10:03:01 GMT

You *really* need to use the '-x' (or '-R') parameter in *every* 'shp2sde -o create' command.
The coordref automatically generated by 'shp2sde' is usually inappropriate, but 900 trillion in the
X/Y scale is spectacularly wrong (unless you're planning on mapping individual hydrogen atoms
in geographic units).

- V