Using sdeimport will generate mojibake in Oracle 11g

StephenLam — Wed, 22 Jan 2014 08:20:08 GMT

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

Re: Using sdeimport will generate mojibake in Oracle 11g

VinceAngelo — Wed, 22 Jan 2014 10:13:54 GMT

First off, that website is in violation of copyright law -- Even old documentation,
in fact, especially old documentation is not "public". Second, ancient documentation
doesn't apply to modern software (and 8.3 SQL-Server variables don't apply to
Oracle ArcSDE clients). Third, Oracle is quirky when it comes to international
character support -- you're probably missing a number of environment variables,
in both ArcSDE instances, before this transfer will work (and that assumes that
the database was originally instantiated with a character set which is compatible
with your target).

What character set did you use with your servers?
How is the NLS_LANG variable set?
Are you using an application server or Direct Connect?
Does the souirce database contain properly encoded UTF-8 or UTF-16 strings?

- V

topic Re: Using sdeimport will generate mojibake in Oracle 11g in Data Management Questions

Using sdeimport will generate mojibake in Oracle 11g

Re: Using sdeimport will generate mojibake in Oracle 11g