Configuration for VARCHAR String Data Type
All databases support more than 4000 characters for the VARCHAR string data type. To enable the maximum characters limit for the length of a string attribute, you must change the configuration based on the database. However, it is best to avoid specifying more than 4000 characters in PRODUCTID and PRODUCTEXT because they are used as identifiers for a record.
You can specify the maximum length of a string attribute in the Configurator by changing the value of the Maximum Attribute Length property. By default, the value is 4000 characters. The maximum supported length varies according the database you have configured. You can specify the size when defining the attribute in TIBCO MDM Studio.
The following configuration is specific to the Oracle database.
| Configuration to enable the maximum characters | Changes in the Configurator |
|---|---|
|
Change the value of the Note: You cannot change the value of
MAX_STRING_SIZE from EXTENDED to STANDARD. |
Set the value of Use standard hash for index creation (com.tibco.cim.oracle.forIndex.useStandardHash) property to true to create indexes for the EXTENDED type. |
Upgrade database tables
TIBCO MDM stores some of the attribute values in the database table. Therefore, to upgrade all built-in database tables, you must run the upgradeAttributeLength.sql script located at $MQ_HOME/db/DatabaseType/install/scripts/utility.
upgradeAttributeLength.sql script to fix issues that occur during seed data creation for exceeded length. After you change the value of the MAX_STRING_SIZE parameter from STANDARD to EXTENDED, a few errors might occur during seed data creation. For information, see Troubleshooting with Oracle Database.Run the upgradeAttributeLength.sql script and call the UPGRADE_ATTRIBUTE_LENGTH function by passing the attribute length, the script upgrades the length of TIBCO MDM database tables. Ensure that TIBCO MDM is running when running the script.
- For example, for the Oracle database, run the script with the following function:
BEGIN
UPGRADE_ATTRIBUTE_LENGTH(32767);
END;
==========================
- For example, for the PostgreSQL database, run the script with the following function:
select UPGRADE_ATTRIBUTE_LENGTH(20000);
upgradeAttributeLength.sql script, however, do not need to call the UPGRADE_ATTRIBUTE_LENGTH function. Running the script executes the function in the database. The length of database tables in the SQL server database contain more than 4000 characters.