WordCustomRefiner2#afd1ca55-403d-404c-b60c-692906bef937
WordCustomRefiner3#cb001ab7-1f19-4da1-8860-3e04d243802c

How to Enable and to Display Double-Byte Character Sets in Microsoft Dynamics NAV

Sidste ændret 24. december 2013
Top Solution

Download

This article describes how to enable double-byte character sets (DBCS) in Microsoft Dynamics NAV.
Sign In Popup
Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Close

Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Lock Icon

Your current service plan does not allow access to this information.

To learn more about Microsoft Dynamics Service Plans review our
service plan offerings.

On this page:

  • Overview
  • Important Notice to Customers
  • Downloads
  • Support Information

Overview

This article describes how to enable double-byte character sets (DBCS) in Microsoft Dynamics NAV.

A double-byte character set is a character set that uses 2-byte (16-bit) characters instead of 1-byte (8-bit) characters. Some languages use characters that cannot be represented by using single-byte codes. Both ASCII and EBCDIC are single-byte codes. Languages that use double-byte character sets include Chinese, Japanese, and Korean.

By default, double-byte character sets are disabled in Microsoft Dynamics NAV.

How to enable double-byte character sets

  • Microsoft Dynamics NAV 2009 SP1

To enable double-byte character sets in Microsoft Dynamics NAV 2009 SP1, you must uncheck the Validate Collation property in the Alter Database window by following these steps:

1. Go to File, Database, Alter
2. Go to the Collation tab
3. Uncheck the Validate Collation property

  • Microsoft Dynamics NAV 3.10 - Microsoft Dynamics NAV 2009

In Microsoft Dynamics NAV 3.10 – Microsoft Dynamics NAV 2009, double-byte character sets are enabled in the fin.stx file. To enable double-byte character sets in these versions, you must replace the fin.stx files in the Microsoft Dynamics NAV client installation folder with a DBCS enabled fin.stx file. You can download DBCS enabled fin.stx files for Microsoft Dynamics NAV 3.10 – Microsoft Dynamics NAV 2009 in the Downloads section on this page. Use the fin.stx file that corresponds to the version of Microsoft Dynamics NAV that you are running.

To enable double-byte character sets in Microsoft Dynamics NAV 3.10 – Microsoft Dynamics NAV 2009, extract the fin.stx file from the DBCS_enabled_stx_files.zip file, and then replace the following files:

  • The fin.stx file that is in the Microsoft Dynamics NAV client folder
  • The fin.stx file that is in the ENU subfolder

Change the input language

After you enable double-byte character sets, you must change the input language to correctly display a double-byte character set. To do this, follow these steps:

    1. In Control Panel, double-click Regional and Language Options.
    2. Click the Languages tab, click to select the Install files for complex script and right-to-left languages (including Thai) check box, and then click to select the Install files for East Asian languages check box.
      Note: You must have the Microsoft Windows CD to install the language files.
    3. After you install the language files, click Details on the Languages tab to open the Text Services and Input Languages dialog box.
    4. Under Installed services, click Add, click the language that you want in the Input language list, click to select the Keyboard layout/IME check box, click the language that you want, and then click OK.
    5. When you see the language in the list under Installed services, click OK.
    6. In the Regional and Language Options dialog box, click the Advanced tab.
    7. Under Language for non-Unicode programs, click the language that you want.
    8. To apply the changes, click OK. The operating system automatically restarts.

When you want to type double-byte characters in Microsoft Dynamics NAV or in other applications, you may have to open the Language bar. On the Language bar, click the language that you want. 
Note: The Language bar is automatically installed.

Warning

Microsoft Dynamics NAV is a non-unicode-compliant program. Microsoft Dynamics NAV does not support DBCS natively.

When you enable DBCS within Microsoft Dynamics NAV, you may experience the following behavior.

  • Storage
    DBCS characters cannot be stored in CODE fields. By default, characters in fields that have the Microsoft Dynamics NAV data type of CODE are stored in uppercase format. When this behavior is applied to DBCS characters, different characters can be stored in SQL Server because DBCS characters do not have uppercase equivalents.
  • Sorting
    The sorting behavior for DBCS characters differs from the sorting behavior for ASCII characters. Because the SQL database operates as a back-end database, it must be stored on a non-DBCS codepage. Therefore, sorting on fields that contain DBCS data can be unreliable. Instead, we recommend that you sort on numeric fields or on ASCII-based fields.
  • Third-party retrieval
    DBCS characters are stored by using their ASCII counterparts in the back-end SQL database. The Microsoft Dynamics NAV client translates the ASCII-based data back to the original DBCS characters. Third-party programs do not make data corrections when they retrieve the ASCII characters. Therefore, the characters can be interpreted as invalid.
  • Report fonts
    Changing the FontName property of a field in a report has no effect in a DBCS environment. The font always reverts to the default setting of Helvetica.

Error message if Microsoft Dynamics NAV is not DBCS enabled

If you try to start the Microsoft Dynamics NAV client from a computer that has a double-byte character set input language, but Microsoft Dynamics NAV has not been DBCS enabled, you will receive the following error messages:

  • Microsoft Dynamics NAV 2009 SP1

There is no system code page on your computer that matches the 1252 code page of the Latin1_General_CS_AS collation for the Demo Database NAV (6-0) database.  Your system code pages are: ANSI: XXX, OEM: XXX.
Ensure that the Regional Options of the computer use the correct system language and locale for the code pages to match.  You can also disable the 'Validate Collation' setting for this database. It is possible that certain text data will not be converted correctly when stored in the database. 
Click OK to disable the 'Validate Collation' setting and continue to use the database, or click Cancel to exit.

  • Microsoft Dynamics NAV 3.10 - Microsoft Dynamics NAV 2009

The double-byte character set, code page XXX, on the computer is not supported by this version of Microsoft Dynamics NAV.

Where XXX is code page 932, 936, 949, or 950

  • 932 - Japanese Shift-JIS
  • 936 - Simplified Chinese GBK
  • 949 – Korean
  • 950 – Traditional Chinese Big5   

Top

Important Notice to Customers

We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hotfixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solution.

Top

Downloads

Download Description File type (size)

DBCS_enabled_stx_files.zip

Double-byte character sets enabled stx files for Microsoft Dynamics NAV 3.60 - Microsoft Dynamics NAV 2009

Zip File   (100 KB)

We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hotfixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solution.

Top

Support Information

If you are experiencing issues downloading the install file or documentation, please contact ITMBSSUP@microsoft.com.

For technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can enter a new support request to Microsoft Dynamics® Technical Support from Customer Source or Partner Source under Support >> New Support Request.

You can also contact Microsoft Dynamics® Technical Support by phone using these links for country specific phone numbers.
Partners - Global Support Contacts (requires Partner Source login)
Customers - Global Support Contacts (requires Customer Source login)

Top

https://mbsauthor.partners.extranet.microsoft.com/sites/CSNAV/northamerica/Learning/Pages/Double-ByteCharacterSetsMicrosoftDynamicsNAV.aspx
No
Microsoft Dynamics NAV