Article ID: 220655
Article Last Modified on 10/28/2002
APPLIES TO
- Microsoft Site Server 3.0 Standard Edition
This article was previously published under Q220655
SYMPTOMS
When the French version of Site Server version 3.0 is installed, the Analysis Database Wizard (Assistant Configuration de base de donnes) may fail with the following error:
This error appears in front of a window titled:
Creation de tables d'importation Definition de table: Cookies.
CAUSE
SQL Server was installed with the Code Page 850 instead of ISO.
RESOLUTION
You can either reinstall SQL Server and leave the default Code Page of ISO or you can rebuild the master database, which will cause you to lose any databases currently installed, so you will need to export them to another server first. To change the code page, follow these steps:
- In the Microsoft SQL Server 6.5 folder, on the Start menu, choose SQL Setup.
- Click Continue twice, and then choose "Rebuild Master Database."
- Click Continue, and then Resume to get to the "Microsoft SQL Server 6.5 Rebuild Options" window.
- Click Sets... and choose ISO Character Set (Defaults).
- Click OK, and then continue to click Continue until you start rebuilding.
WORKAROUND
To work around this problem, you can use the English version of Site Server 3.0. The English version of Site Server 3.0 supports Code Page 850.
STATUS
Microsoft has confirmed this to be a problem in the French version of Site Server 3.0.
MORE INFORMATION
When the code page is changed from the default ISO Character Set, a conversion is performed on all data. Each query is translated between ANSI (ISO Character Set = Code Page 1252 on Windows NT) and code page 850. For more information, see the following article in the Microsoft Knowledge Base:
153449 INF: SQL Server Code Pages and AutoAnsiToOem Behavior
The creation of the Analysis database fails on the tblImportCookie CREATE TABLE when a single quote is encountered in the query. The apostrophe is in the "DN_de_l'utilisateur" default value of the UserDN column. For more information on apostrophes in translated SQL Server queries, see the following article in the Microsoft Knowledge Base:
175127 BUG: Character Translation Causes 105, Unclosed Quote Error
Keywords: kbbug kbpending KB220655