String properties
Data Catalog object metadata properties that are defined as type:string have these attributes in Compass:
- INFORMATION_SCHEMA.COLUMNS DATA_TYPE is CHARACTER VARYING.
- JDBC getColumns method TYPE_NAME is 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, though. The query results are based on the result set data directly.
- If your application uses the Compass APIs, the result set data type is String.