Contents IndexDate and time data types User-defined data types

User's Guide
   Part VI. SQL Anywhere Reference
     Chapter 41. SQL Anywhere Data Types
      Binary data types

Purpose

For storing binary data, including images and other information that is not interpreted by the database.

Syntax

     Binary data types:
          BINARY[ ( max-length ) ]
          | LONG BINARY

Description

BINARY [(max-length)] Binary data of maximum length size (in bytes). If size is omitted, the default is 1. The maximum size allowed is 32,767. The BINARY data type is identical to the CHAR data type except when used in comparisons. BINARY values will be compared exactly while CHAR values are compared without respect to upper/lowercase (depending on the case-sensitivity of the database) or accented characters.

LONG BINARY Arbitrary length binary data. The maximum size is limited by the maximum size of the database file (currently 2 gigabytes).

Contents IndexDate and time data types User-defined data types