SQL data type VARCHAR instead of CLOB for array fields
When we create array data type field, the SQL data type is created as CLOB.
Can you please suggest how to create a VARCHAR type instead of CLOB?
Thanks in advance.
Please refer to following KM document.
How to remap one field or all arrays as multi-row array table, performance problems
Hope it helps.
Thanks for the reply.
The KM document you had mentioned provides information about adding clob/blob fields as keys. But my question is how to create the array field with the SQL type as varchar instead of clob field. By default, when we create an array field with character type, the sql type is created as clob. instead of this clob, we want varchar.
I don't think we support that, the array type field will be created as BLOB or TEXT in database.
I think you may map this array type field into a sub table so that you can check the data in that sub table.
If we create array type field in M1 table, the SQL type will be TEXT or BLOB, it is design. the element type in this array type field can be number, varchar. it means SM application will read array type field out and then evaluate the elements in this arrray.
It is degiened.
In our existing SM, when we create any array fields with character type, they are automatically created in the next "a" prefixed tables (like a1, a2..) and the sql type is automatically stored as "VARCHAR2" of size 60.
In that case, is there any configuration settings for this in any of the SM table?