| # Microsoft SQL Server To install the Microsoft SQL (MSQL) software, use the MSQL Installation Manuals. Belangrijk! Documents with the latest (version) information about the database: Infor Enterprise Server - Technical Notes Infor Enterprise Server - Technical Notes for Porting Set x.x Overview of the installation process Microsoft SQL Server installations are version-dependant and systemdependant. Check your Microsoft SQL Server documentation for the specific installation procedure of the SQL version you want to install. Online Help is available on the SQL Server Setup windows. Specific ERP LN Note If during the installation process of SQL the Collation Settings dialog box appears, select Collation designator and sort order together with the Binary check box to specify a binary sort order: However, in case of a Unicode install, select the following: Collation designator and sort order. Together with: Case - sensitive Accent - sensitive Kana - sensitive Width - sensitive Collation Settings NB The binary sort/collation only applies for native mode installations and not for unicode mode installations. A sort order is a set of rules that determines how SQL Server assembles and presents data in response to database queries. Select the correct sort order during the installation of SQL Server. If you have to change sort orders after you install the SQL Server, rebuild your databases and reload your data. NB Select Windows collation designator and sort order with Latin1_General as the collation designator. Make sure you also select the Binary check box and not the Binary-code point checkbox. Locale and collation setting for Multi-byte (not Unicode) environments. To store native multi-byte (not Unicode) characters in a SQL-Server database, the SQL server collation, the Windows system and the locale of the ERP LN environment must be compatible with eachother. For example, when the used multi-byte language is SHIFTJIS, the system locale must be Japanese (Japan). To change the system locale, use the “Regional and Language” settings, Administrative tab -> Change system locale. The settings can differ for other Windows versions. The collation of the SQL server database must be setup at creation time of the database, or SQL server instance. In the following list the ERP LN locale, the O.S. locale and the SQL-Server collation which are compatible with eachother.
ERP LN locale | Windows system locale | SQL-Server collation
SHIFTJIS_WIN32 | Japanese (Japan) | Japanese_BIN
GB_WIN32 | Chinese (SIMPLIFIED, PRC) | Chinese_PRC_BIN
BIG5_WIN32 | Chinese (Traditional, Taiwan) | Chinese_Taiwan_Stroke_BIN
KOREAN_WIN32 | Korean (Korea) | Korean_Wansung_BIN
NB Note the binary sort order of each SQL server collation. Newer SQL versions also support _BIN2. If all required SQL software is installed and configured, you are ready to start the Staging Wizard. For more information, refer to the Overall installation guide for Infor ERP LN products (U9498 US). |