String properties

This table shows the string Data Catalog object metadata attributes in Compass:

String Data Catalog object metadata properties Attribute in Compass
INFORMATION_SCHEMA.COLUMNS DATA_TYPE CHARACTER VARYING
JDBC getColumns method TYPE_NAME CHARACTER VARYING

Properties that are defined with a maxLength use column size in the INFORMATION_SCHEMA.COLUMNS, CHARACTER_MAXIMUM_LENGTH, and CHARACTER_OCTET_LENGTH.

The JDBC getColumns method includes the COLUMN_SIZE and CHAR_OCTET_LENGTH.

Properties without a maxLength attribute default to a column size of 255. The size does not limit or truncate results. The query results are based on the result set data directly.

If your application uses the Compass APIs, then the result set data type is String.