Set SQLASCII ON is used when importing EXCEL spreadsheets or any other ODBC compliant data in a procedure using the associated Import ODBC/OPENEXCEL or SQL commands. This command is OFF by default.
When this preference is ON:
| • | Any SQL-based Unicode data that is read is converted to ASCII. This preference should only be used if you are confident that the source data only contains North American English characters |
| • | The keyword ASCII is automatically added to the SQL command created from the SQL command dialog and the resulting Import command for data defined via the Data Definition Wizard. |
| • | Any previously created Import or SQL commands in existing procedures will be treated as if they contain the ASCII keyword |
See Convert Imported Unicode Data to ASCII for setting this preference globally.
Note: For the SQL command and the Data Definition Wizard's File Format and Select Data Source or Subsystem panel, if the chosen Data Source or DSN name includes Unicode characters then this option must be turned off.
SET SQLASCII <OFF|ON>