Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL » Interactive SQL options

commit_on_exit option [Interactive SQL] Next Page

default_isql_encoding option [Interactive SQL]


Specifies the code page that should be used by READ, INPUT, and OUTPUT statements.

Allowed values

Identifier or string


Use system code page (empty string)


Can be set as a temporary option only, for the duration of the current connection.


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 computers, the default code page is 1252.

Interactive SQL determines the code page that is used for a particular INPUT, OUTPUT, or READ statement as follows, where code page values occurring earlier in the list take precedence over those occurring later in the list:

For more information about code pages and character sets, see International language and character set tasks.

See also

Set the encoding to UTF-16 (for reading Unicode files):

SET OPTION default_isql_encoding = 'UTF-16';