importing Oracle table definition changes data type
Posted: Mon Jul 01, 2013 5:13 pm
Hello,
We just converted from 7.5 to 8.7, and have noticed that when we import table definitions using the Oracle Connector Import Wizard, it is changing Char columns to NChar and VarChar2 to NVarChar. I have found references to this in previous posts and within the DataStage documentation, but I am still not clear on *why* it does this conversion and if it's a problem. So far we have been manually changing each column back to the original format. Can anyone advise? Our NLS_CHARACTERSET for the database is AL32UTF8, so it is multi-byte, but our DBA is concerned that the NChar/NVarChar settings will cause the database to use more storage for the same data.
Thanks in advance for any input.
We just converted from 7.5 to 8.7, and have noticed that when we import table definitions using the Oracle Connector Import Wizard, it is changing Char columns to NChar and VarChar2 to NVarChar. I have found references to this in previous posts and within the DataStage documentation, but I am still not clear on *why* it does this conversion and if it's a problem. So far we have been manually changing each column back to the original format. Can anyone advise? Our NLS_CHARACTERSET for the database is AL32UTF8, so it is multi-byte, but our DBA is concerned that the NChar/NVarChar settings will cause the database to use more storage for the same data.
Thanks in advance for any input.