Skip to Content
author's profile photo Former Member
Former Member

About importing exported data from UnicodeDB to ASCII DB


I have one question.

One of our customer is planning to install ECC6.0 non-unicode system on AIX/DB2 UDB.

They will also planning to import the CSV file through batch input. Source DB2(not SAP system) is using UTF-8 and target SAP/DB2 system is ASCII system.

I recommend the customer that we should install unicode system but because of the CPU/Memory/DISK limitation, they want to install non-unicode system.

Is there any consideration points?

Could you tell me what we should pay attention to?

Thank you and best regards,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2006 at 11:12 PM

    Hi Takae,

    The biggest thing to pay attention to when you have a mixed Unicode/non-Unicode landscape is the data transfer between these systems in the landscape. In a nutshell, receiving systems can only store data with the codepage of the system.

    The quickest example of this involves the Eurodollar symbol (€). The Eurodollar symbol does not exist on the Latin-1 codepage (most common codepage for English systems). So, if your receiving system is on Latin-1 and € is sent, it ends up getting stored in the DB as # and the data is lost. The problem is even more acute when sending systems are double-byte and the receiving systems are single-byte, as fully half the data can be lost.

    Best Regards,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.