Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.



Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.



Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

Multi-Language Support

  • 1.  Multi-Language Support

    Posted Fri August 28, 2020 09:42 AM

    "Because Maximo doesn't support UTF-8 for SQL Server, multilingual support is limited. You can support multiple languages on one database instance only if they share the same character set. For example, a database instance could support English, French, and Portuguese because they use the same character set.  A database instance could not support both Portuguese and Chinese because they have different character sets. For Turkish on SQL Server, collation can't be set to Turkish as maxinst fails due to the Turkish i problem. It can be added to a database with English collation but some of the characters will be corrupted."

    Question is:->
    In a Maximo instance with SQL database where  English, Dutch, German are implemented can the same instance support Japanese and Chinese.  

    If not can separate Maximo SQL instance be configured for Japanese and Chinese.

    I also found another link which contradicts to the above

    Please clarify on the above.


  • 2.  RE: Multi-Language Support

    Posted Mon August 31, 2020 08:50 AM
    1) No, Maximo cannot currently support Latin based languages alongside other character languages like Japanese & Chinese in a SQL Server environment.
    2) I don't believe it's possible as Japanese & Chinese use different character sets to the best of my knowledge. You can have a Japanese or Chinese SQL Server Maximo instance, the issue is mixing the languages in a single environment.
    3) The platform matrix covers language support, however, SQL Server support is more limited than DB2/Oracle today. While each language is allowed separately in SQL Server, there are restrictions on what can be combined together.  

    Maximo (the July 24, 2020 release) added support for SQL Server 2019, which now supports UTF-8. SQL Server has traditionally supported UTF-16 (which IBM doesn't support with Maximo), but with the support of UTF-8 it is now theoretically possible with minimal changes to Maximo to add additional language support that mixes character sets. We've confirmed that IBM doesn't officially support this yet, but it's something they're looking to certify.

    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH