Import NLS Considerations

Restriction: This topic applies to Windows environments only.

You need to be aware of character set conversion issues when importing data, especially if:

Your data contains diacritical (accented) or other characters that lie outside the first half of the ASCII character set
Your data was created using a variety of EBCDIC code pages

If you are importing EBCDIC data using SQL Wizard, we recommend using the DSNTIAUL data format as this enables you to specify an appropriate EBCDIC to ANSI or ANSI to EBCDIC conversion.

You specify the appropriate conversion by picking an entry in the code page window. For example, to import a Spanish EBCDIC table, you would pick the EBCDIC to ANSI translation 284 - 1252.