Progress
Version 9
Product Update Bulletin


Bit String Data Type Enhancements

This section describes the changes to the VARBINARY and VARCHAR data types, and the new LONG VARBINARY data type.

This is the new syntax for a bit_string_data_type:

SYNTAX
BIT | BINARY | VARBINARY | LVARBINARY [ ( length ) ] 

VARBINARY ( length )

Type VARBINARY corresponds to a variable-length bit field of the specified length. The maximum length is 31995.

LVARBINARY ( length )

Type LVARBINARY corresponds to an arbitrarily long byte array with the maximum length defined by the amount of available disk storage up to 2,000,000,000. A BLOB is an object of data type LVARBINARY.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095