Interactive SQL behavior changes

Following is a list of changes to Interactive SQL introduced in version 12.0.1.

  • READ statement encoding algorithm changed   When running the READ statement in Interactive SQL, the encoding that is used to read the data is now determined in the following order:

    1. The encoding specified by the ENCODING clause (if this clause is specified).

    2. The encoding specified by the byte order mark in the file (if byte order mark is specified).

    3. The default TEXT format encoding (if the format encoding is specified).

    4. The default encoding for the platform you are running on. On English Windows computers, the default encoding is 1252.

    See READ statement [Interactive SQL].

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1