IBM Support

SQL collation setting for Chinese characters in Maximo 7.6

Technical Blog Post


Abstract

SQL collation setting for Chinese characters in Maximo 7.6

Body

Our official collations tested by Globalization group is as below and we do not support mixing Traditional and Simplified Chinese.

Simplified Chinese : Chinese_PRC_CI_AS

Traditional Chinese : Chinese_Traditional_Stroke_CI_AS


There are no changes necessary to connection strings in the maximo.properties file for 7.6


Please refer to our info center for preparing and manually configuring your SQL Server.

- Microsoft SQL Server preparation

http://www-01.ibm.com/support/knowledgecenter/SSLKT6_7.6.0/com.ibm.mam.inswl.doc/install/c_SQLServerPreparation.html?lang=en


- Manually configuring Microsoft SQL Server 2012

http://www-01.ibm.com/support/knowledgecenter/SSLKT6_7.6.0/com.ibm.mam.inswl.doc/install/t_ccmdb_manconfigdbsqlserver.html?lang=en

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11111695