Amazon Redshift announces support for VARBYTE data type
Amazon Redshift has launched support for the VARBYTE data type. VARBYTE is a variable size data type for storing and representing variable-length binary strings. With this announcement, Amazon Redshift can now support variable length binary data for use with core Amazon Redshift features, SQL UDFs and SQL DDL for creating VARBYTE columns in tables. VARBYTE(n) syntax gives you the flexibility to specify the size (‘n’). The default for n is 64KB and max is 1MB. VARBYTE values are displayed/printed as Hex values to ensure all binary bytes are printable.
Amazon Redshift has launched support for the VARBYTE data type. VARBYTE is a variable size data type for storing and representing variable-length binary strings. With this announcement, Amazon Redshift can now support variable length binary data for use with core Amazon Redshift features, SQL UDFs and SQL DDL for creating VARBYTE columns in tables. VARBYTE(n) syntax gives you the flexibility to specify the size (‘n’). The default for n is 64KB and max is 1MB. VARBYTE values are displayed/printed as Hex values to ensure all binary bytes are printable.
VARBYTE support is now available in all commercial AWS Regions. Refer to the AWS Region Table for Amazon Redshift availability. For more information or to get started with Amazon Redshift, see the documentation.