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 2010Shape 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.