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.