How can I import a data into a Windows NT OS (SJIS) coming from a UNIX based OS (EUC)

Good day to you........

I would like to ask for some assistance with regards to the import process of data into the Oracle database.

The data used for the import process will come from the Sun Solaris UNIX's Oracle database server. The UNIX machine uses the EUC (japanese) character set--thus, the data that will be exported will inherit the character set of the UNIX system. On the other hand, the Oracle database server that will execute the import application of data will be in a Windows NT (japanese) based OS. The S-JIS (Shift JIS) character set is being used by the Windows NT based operating system.

Upon execution of the import process, the Oracle import application returns an error that prompts the user that different character sets were used and that it cannot continue the import process.

The question will be: how can I import the data file that was exported from the UNIX server that uses the EUC character set into the Windows NT server that uses the S-JIS character set?

Thank you for your response.

--

     ||||||                       "Omnia Vincit Amor!"
      o  o                      - Lowell Felix Tortona -
        L                 Engineering Project Leader (INFOSYS)
        V                 Tsukiden Software Technologies, Inc.
    /      |              E-Mail: (home)   ltortona_at_pacific.net.ph
----------------                  (office) ltortona_at_tspi.com.ph
                          Mobile  : +63 917 529-3516   (GSM)
                          Tel.    : +63 2    641-1521    (Home/Fax)


                                  : +63 2    635-8106    (Office)


                                  : +63 2    635-8105    (Office)


                                  : +63 2    633-4039    (Office Fax)


                          UIN     : 18552336