Does SCCM Database support Unicode characters?

| 0 comments

Recently, we had the above question raised from one of our customers and I answered his question with the following answer which I think should be a good candidate for a blog post since many customers might have the same question as well

SCCM 2007 database  doesn’t supports Unicode characters yet. Hence in ConfigMgr,  Language support is solely dependent on the system locale of the clients which updates the database.

So in order to  view data collected from or directed to clients that are using a specific language, you must run the appropriate language version of the Configuration
Manager console on a computer set to the corresponding locale. For each client language other than Japanese, Korean, Simplified Chinese, or Traditional Chinese, inventory data is viewed from a Configuration Manager console by changing the locale setting on a computer running a U.S. English operating system.

Do I need to perform any setting at the SQL Instance to view foreign language data other than English?

There is no setting which needs to be performed from the SQL end to view the data.

But instead install remote Admin UI on other machines with same system locale as the client language and connect to central site. for example, you have ENU central site with CHS, CHT, JAP client, then you need to install remote Admin UI (can be ENU or localized) on the CHS OS or CHT OS or JAP OS to view them correctly.

For viewing only the SCCM Reports, change the IE browser’s Encoding settings to that locale and the reports can be viewed.

Following Reference should help clarify this.

http://technet.microsoft.com/en-us/library/dd547071.aspx

Multilanguage Site Hierarchy Considerations

English SQL Server (codepage 1252) or Configuration Manager installations are supported on any localized operating system. For example, the English language version of SQL Server can be installed on a Dutch language version of a supported server operating system to support an English language Configuration Manager installation.

Localized SQL Server installations (codepage 1252) are supported to host the site database for the same-language operating system installation supporting either the English or the same-language localized version of Configuration Manager. For example, a Japanese language SQL Server installation using the 1252 codepage can be installed on a Japanese language version of a supported server operating system to support either a Japanese or English language Configuration Manager installation.

Localized SQL Server or Configuration Manager installations are supported on any same-language operating system installation. For example, the German language version of SQL Server can be installed on a German language version of a supported server operating system to support a German language Configuration Manager installation.

The following table describes the supported language version interoperability for localized Configuration Manager 2007 site installations. For more information about deploying Configuration Manager 2007 sites in multilanguage environments, see Deploying Configuration Manager Sites in International and Multi-Language Environments.

image

image

Hope this helps !!!

Parikshit Savjani
Premier Field Engineer, Microsoft

Leave a Reply

Required fields are marked *.