Specifies the code page that should be used by READ and OUTPUT statements.
identifier or string
Can be set as a temporary option only, for the duration of the current connection.
Use system code page (empty string)
This option is used to specify the code page to use when reading or writing files. It cannot be set permanently. The default code page is the default code page for the platform you are running on. On English Windows machines, the default code page is 1252.
Interactive SQL determines the code page that is used for a particular OUTPUT or READ statement as follows, where code page values occurring earlier in the list take precedence over those occurring later in the list:
the code page specified in the ENCODING clause of the OUTPUT or READ statement
the code page specified with the DEFAULT_ISQL_ENCODING option (if this option is set)
the code page specified with the -codepage command-line option when Interactive SQL was started
the default code page for the computer Interactive SQL is running on
For a complete list of supported code pages, see the Adaptive Server Anywhere Database Administration Guide.
READ statement [DBISQL] in Chapter 6, “SQL Statements” of the Sybase IQ Reference Manual
OUTPUT statement [DBISQL] in Chapter 6, “SQL Statements” of the Sybase IQ Reference Manual
“Pieces in the character set puzzle” in Chapter 11, “International Languages and Character Sets” of the Sybase IQ System Administration Guide
Set the encoding to UTF-16 (for reading Unicode files):
SET TEMPORARY OPTION DEFAULT_ISQL_ENCODING = 'UTF-16'
