Here is the setup. I have a SQL Server 7 DB in China that I need to move to
a SQL 2000 machine in US.

I have tried several different methods, but the Chinese characters are
always messed up.

I have created the Server/Database with the CHinese_PRC_CI_AS collation,
which matches the SQL7 database.

I have restored from a backup, and even detached the database from the 7.0
and attached it to the 2000. Same thing.

Both servers are English (Win2k & SQL). They have the appropriate Language
packs installed.

If I open up Enterprise Manager, I can manually type the Chinese characters
in through the IME, and they appear correctly, but the ones transferred do
not show the correct character.

I have looked at the actual Unicode value of the characters in the field
and verified that they are all single byte.

On the detach/attach, the tech in China detached the database, made a copy
and Rar'd it, then FTP to my server.

Is it possible that the saving/copying/zipping has affected the data?

Any suggestions are greatly appreciated.