Verifying code page settings for SQL Server
The procedure in this section outlines the minimum requirements of a SQL Server environment to run Release 9.2. After completing this procedure, the database might still require significant modifications, such as tuning the system, creating backup or recovery procedures and jobs, and maintaining or expanding the database system.
Note: When installing or upgrading an
alternate language, the correct code page settings must be in your database. When
installing or upgrading the database, set up the code page for the language before
loading your language specification objects for Release 9.2. Review
the LocalCodeSet and code page settings for your database machine
environment.
From an ISQL window, enter this command:
sp_helpsort
Caution: If the character set
is incorrect, recreate the database with the correct character set.
See Also
Refer to the Language Process Overview for the National Language Support tables and other information related to multilingual installations.