RE: unable to 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:12:22 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. For example:

  setup.exe COLLATION=SQL_Latin1_General_CP1_CI_AS
  setup.exe COLLATION=Chinese_Taiwan_Bopomofo_CI_AS
  setup.exe COLLATION=Chinese_PRC_CI_AS

HTH,
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: unable to determine default collation
thread-index: AcRS9OOXTYpyph85RCClAuJvdqXOgA==
X-WBNR-Posting-Host: 203.168.166.203
From: =?Utf-8?B?c2Fu?= <san@discussions.microsoft.com>
Subject: unable to determine default collation
Date: Tue, 15 Jun 2004 09:22:01 -0700
Lines: 3
Message-ID: <90789F18-55F0-42CB-8018-EED49E1BBBFE@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.server
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA06.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGX
A01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:346062
X-Tomcat-NG: microsoft.public.sqlserver.server

when i tried to install the lastest MSDE release A, it has this error.

I am using windows 2000 pro, with Traditional Chinese (Hong Kong) as
locale.

Relevant Pages

  • RE: Cannot 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 (e.g. ... thread-index: AcRS8jxBIFmv0lEuTbeceZiciXUOYg== ...
    (microsoft.public.sqlserver.msde)
  • 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)