LONG VARBINARY

The LONG VARBINARY data type is a variable length data type that can contain any binary value. The maximum length of LONG VARBINARY columns is 2 gigabytes, or about 2,000,000,000 bytes. Unlike BINARY data type which uses zero-value bytes for padding, only the bytes entered are stored in the database.

You can enter character data by enclosing the data in single quotes (' '), the same as when entering CHAR data. However, in LONG VARBINARY columns the data is stored as hexadecimal values representing the ASCII code of the characters, not as the actual characters you entered.

You can also enter hexadecimal values directly by enclosing the data in single quotes and appending the 'x' character (' 'x) to indicate the string contains a hexadecimal value. Since it requires two digits to represent all possible values for each byte in hexadecimal, you must use an even number of digits when entering hexadecimal values.

< INTEGER | Contents | LONG VARCHAR >