Question & Answer
Question
How to increase the character size of a database column upon enabling multibyte support in IBM Sterling Order Management?
Cause
Database column complaints about exceeding character limit.
Answer
For multibyte support, you can enable SUPPORT_MULTIBYTE=true property in sandbox.cfg file from %INSTALL_DIR%/properties directory. By default this property is false.
But, there are cases where, though multibyte support is enabled but character size will not get increased.
For example:
CITY column in YFS_PERSON_INFO table.
The attribute ResizeForMultibyte="Y" helps to resize the length of a column when used with multibyte enabled.
Add this attribute in extensions.xml file which is in <install_dir>\extensions\global directory for the particular column as needed.
Bellow is the example where ResizeForMultibyte is used for CITY column of YFS_PERSON_INFO table.
<Entity TableName="YFS_PERSON_INFO">
<TableType Name="CONFIGURATION"/>
<TableType Name="TRANSACTION"/>
<Attributes>
<Attribute ColumnName="CITY" ResizeForMultibyte="Y"/>
</Attributes>
</Entity>
Build the entities jar and EAR post the above changes.
Was this topic helpful?
Document Information
Modified date:
10 May 2022
UID
swg21681331