Microsoft KB Archive/890602

= How to use GB18030 characters in BizTalk Server 2004 Service Pack 1 =

Article ID: 890602

Article Last Modified on 12/13/2004

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Standard Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Partner Edition

-





CONTENTS

 * INTRODUCTION
 * Understand SQL Server set up
 * Install Windows SharePoint Services
 * Install Service Pack 1 with binary collation
 * Uninstall Service Pack 1 with binary collation
 * Understand known issues



INTRODUCTION
Microsoft BizTalk Server 2004 Service Pack 1 supports the Chinese character encoding schema that uses GB18030 characters. This article describes how to set up BizTalk Server 2004 Service Pack 1 to use GB18030 characters.

For additional information about GB18030 characters, visit the following Microsoft Web site:

http://www.microsoft.com/globaldev/DrIntl/columns/015/default.mspx

Because Microsoft SQL Server 2000 does not recognize GB18030 characters, you must configure a computer that is running SQL Server 2000 to use binary collation. When you do this, adjustments may be required to certain adapters. If you use Business Activity Services (BAS), this may affect how you install Microsoft Windows SharePoint Services.

back to the top



Understand SQL Server set up
To use GB18030 characters, you must set the instance of SQL Server to binary collation. You only have to set the collation on the instance of SQL Server that is used by BizTalk Server.

When you set the collation to binary collation, this makes sure that all tables use binary collation. This includes internal tables that are created by BizTalk Server. You have to do this because BizTalk Server does not support mixing databases that use binary sort orders with databases that do not use binary sort orders.

Note When you configure BizTalk Server to use a binary collation in an instance of SQL Server, you cannot configure existing databases. Start with clean databases. Also, if you upgrade your version of BizTalk Server, you must also start with clean databases after you install Service Pack 1 and binary collation. An example of a version upgrade is from BizTalk Server Standard Edition to BizTalk Server Enterprise Edition.

back to the top

Install Windows SharePoint Services
If you use BAS, you must install Windows SharePoint Services (WSS). WSS does not configure correctly when you use binary collation in your SQL Server databases.

To work around this problem, install WSS by using the &quot;server farm&quot; option. Make sure that you specify the SQL Server database that is not using binary collation.

You can also configure WSS to use the Microsoft SQL Server 2000 Desktop Engine (MSDE). This is the default configuration. Make sure that you locate your BizTalk-related SQL Server installation on a different computer. MSDE and BizTalk require different shared memory settings.

back to the top

Install Service Pack 1 with binary collation
 If you have not already installed Windows SharePoint Services, do this now.

Note For additional information, visit the following Microsoft Web site to see the &quot;Administrator's Guide for Windows SharePoint Services:&quot;

http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsk11.mspx

 Configure your computer that is running SQL Server to use binary collation.

Note For additional information about how to set up you computer that is running SQL Server, visit the following Microsoft Web site:

http://www.microsoft.com/resources/documentation/sql/7/all/proddocs/en-us/intro/part2/75515c02.mspx

 Run the Setup program for BizTalk Server 2004. Do not run the Configuration Wizard right now. On the final page of the Installation Wizard, click to clear the Start Configuration Wizard check box.

Note This prevents the Configuration Wizard from automatically starting. Do not run the Configuration Wizard until you install Service Pack 1. Install BizTalk Server 2004 Service Pack 1. Run the BizTalk Server Configuration Wizard. To run the Configuration Wizard, follow these steps: <ol style="list-style-type: lower-alpha;"> Locate the BizTalk Server installation directory.

Note The default location for the installation directory follows:

%ProgramFiles%\Microsoft BizTalk Server</li> Double-click ConfigFramework.exe.</li></ol> </li></ol>

back to the top

Uninstall Service Pack 1 with binary collation

 * 1) To uninstall the BizTalk Server configuration, click Start, click Run, type &quot;%ProgramFiles%\Microsoft BizTalk Server\configframework.exe /u&quot;, and then click OK.
 * 2) Uninstall Service Pack 1.
 * 3) Rebuild your instance on the computer that is running SQL Server to use standard collation.
 * 4) Rerun the BizTalk Server 2004 Configuration Wizard to use standard collation databases.

Note If you uninstall Service Pack 1 with binary collation, and then you reinstall it, you cannot use your old databases.

back to the top

Understand known issues
The following are known issues in BizTalk Server Service Pack 1.

FTP Adapter
Because of the limitations of the FTP protocol, you cannot use GB18030 characters in user names, in passwords, or in file names that are used by the FTP adapter. However, these characters may appear in messages that are processed with the adapter.

SQL Adapter names and schemas
Sometimes you cannot use the following special characters in schema generation:
 * space
 * Unicode surrogate pairs
 * Unicode surrogate pairs
 * Unicode surrogate pairs

For additional information about valid characters, see &quot;XMLConvert class&quot; in the Microsoft .NET Framework Class Library Help files.

You can work around some of these problems by using an alias in the SQL statement. For example, an alias can be used to enable GB18030 characters in a table name by using the SELECT statement in the following code example. SELECT x FROM tableNameWithGB18030 aliasedTableNameWithoutGB18030 For additional information about creating schemas and about using schemas with the SQL adapter, see &quot;Adding SQL Adapter Schemas to a BizTalk project&quot; in the BizTalk Server 2004 Help files.

Working with Business Activity Monitoring
The Business Activity Monitoring (BAM) Excel worksheet does not work with GB18030 characters. You have to restrict BAM data items to Unicode 2.0 characters.

back to the top

Keywords: kbhowto KB890602

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.