I'm working on Migration of data from Flat Files to Oracle 8.0.5 database. I'm facing 2 major problems any suggestions would be highly appreciated:
1. How to migrate Special characters like TM - Trade Mark or R - Registered the symbols appear along with any company logo? Small characters appearing on top of the banner.
2. Double-byte characters
During insertion of data, only data length is taken into consideration. Double-byte characters in text file are the same length as single-byte characters. Hence, when inserting data, the record will not be inserted if the double-byte characters exceed half the length of the size for VARCHAR2 datatype.