Question & Answer
Question
Post installation, how to make database to support multibyte character ?
Cause
When trying to insert any value with Chinese or Japanese characters, four times more length is used in the database. The default Sterling Order Management System (OMS) installation will not support multibyte values to add in the column, because there might be problems with character length.
Answer
To support multibyte after installation:
1. Change the sandbox.cfg property as shown below from <Install-Dir>\properties folder
SUPPORT_MULTIBYTE=true
2. Run the setupfiles.sh from <Install-Dir>\bin folder
3. Run Dbverify.sh from <Install-Dir>\bin folder.
4. Dbverify will generate set of SQLs to alter the column size. Run these SQLs to alter database length.
5. After running dbverify command, entities jar needs to be rebuilt. This will make sure db classes are regenerated according to the latest changes made in db.
Or--
Instead of running dbverify, you can directly run entitydeployer. This will generate the SQLs, execute them, and regenerate db classes.
To run entitydeployer, run the following command from install_dir\bin directory.
./deployer.sh -t entitydeployer (Linux)
or
deployer.cmd -t entitydeployer (Windows).
Was this topic helpful?
Document Information
Modified date:
10 May 2022
UID
swg21681326