stephenlam1988

Using sdeimport will generate mojibake in Oracle 11g

Discussion created by stephenlam1988 on Jan 22, 2014
Latest reply on Jan 22, 2014 by vangelo-esristaff
I am doing a data conversation from ArcSDE 9.0 Oracle9i  Build 325 to ArcSDE 10.1  for Oracle11g Build 679
I run the following command with sde9.0
set SDE_SQLCHARSET=big5
sdeexport -o create -t BLDG -f BLDG.sdeexp -s 10.5.1.26 -u xxx -p xxx

and then run the following in sde 10.1
set SDE_SQLCHARSET=big5
sdetable -o delete -t BLDG -u xxx -p xxx -N
sdeimport -o create -t BLDG -f BLDG.sdeexp -u xxx-p xxx

However, all the chinese characters are incorrect(mojibake) in database, please advice, thank you.

PS: for the set SDE_SQLCHARSET=big5, please refer to page 71 - 73
http://www.zmuc.dk/public/GIS-intro/Litteratur/ESRIdigitalBooks/config_tuning_guide_SQLServer.pdf

Outcomes