RE: Cannot determine default collation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bart Duncan [MSFT] (bartd_at_online.microsoft.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 18:10:05 GMT

See the following KB article for more info on this problem:
http://support.microsoft.com/?id=838302

You can avoid the problem by (temporarily) changing your default system
locale to a locale that isn't in the list in that article, reboot, then
retry the installation. You can also avoid the problem by passing the
COLLATION command line parameter to setup (e.g.
"COLLATION=SQL_Latin1_General_CP1_CI_AS".

Bart
------------
Bart Duncan
Microsoft SQL Server Support

Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no
rights.

--------------------
Thread-Topic: Cannot determine default collation
thread-index: AcRS8jxBIFmv0lEuTbeceZiciXUOYg==
X-WBNR-Posting-Host: 61.10.7.203
From: =?Utf-8?B?U2Fu?= <San@discussions.microsoft.com>
Subject: Cannot determine default collation
Date: Tue, 15 Jun 2004 09:03:01 -0700
Lines: 1
Message-ID: <9101766C-F170-4F20-A300-554889E2A0C2@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
        charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.msde
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNG
XA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.msde:15056
X-Tomcat-NG: microsoft.public.sqlserver.msde

when i tried to install the lastest MSDE release A, it has this error.
How should I solve it?

Relevant Pages

  • RE: unable to determine default collation
    ... You can avoid the problem by changing your default system ... locale to a locale that isn't in the list in that article, reboot, then ... COLLATION command line parameter to setup. ... thread-index: AcRS9OOXTYpyph85RCClAuJvdqXOgA== ...
    (microsoft.public.sqlserver.server)
  • Re: Moving Servers, Matching Collation
    ... If you change your default locale to U.S., that will be sufficient to have ... setup default to SQL_Latin1_General_CP1_CI_AS just as you say. ... When you reach the "Collation Settings" dialog, ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.setup)
  • Re: DateTime Problem
    ... When you use DateTime.Parseit uses the computer's default locale ... To avoid this sort of problem you should send DateTime.Parse an ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Alphabetical sorts
    ... Collation is almost always locale dependant. ... One day I needed collation that worked on Windows and Linux. ... '''Grab character encoding from locale name''' ... def setup_locale: ...
    (comp.lang.python)
  • Re: [9fans] awk, not utf aware...
    ... generally i avoid the mb functions because they ... rely on locale. ... of course this doesn't apply on plan 9 and so there's no reason ... mbtowc/wctomb functions to deal with UTF. ...
    (comp.os.plan9)