RE: Collation

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

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

Date: Thu, 26 Aug 2004 16:44:07 GMT

Select "SQL collations" at the collation selection dialog, then select
"Binary Order, for use with the CodePage 850 Character Set" (same sort
order that sp_helpsort reports for your 7.0 server).

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: Collation
| thread-index: AcSLbDA3HenK5wRzRMK500SXnoE2ZQ==
| X-WBNR-Posting-Host: 199.20.71.17
| From: "=?Utf-8?B?U0IxMzg=?=" <SB138@discussions.microsoft.com>
| Subject: Collation
| Date: Thu, 26 Aug 2004 05:57:05 -0700
| Lines: 14
| Message-ID: <453BEDBF-EFD3-4F90-B477-547692531EB2@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 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:356327
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have following collation setting in my current sql 7 server.
| Locale ID = 33280
| case sensitive
| Sort Order Description
   
|
| Character Set = 2, cp850
| Code Page 850 (Multilingual) character set.
| Sort Order = 40, bin_cp850
| Binary Sort Order for the CodePage 850 Character Set
|
| I plan to install sql 2000 on a new server and restore backup from sql 7.
| What Locale ID and collation setting I should be using in sql2000.
| Thanks
|
|

Relevant Pages

  • Re: sql 2003 special characters
    ... Can somebody tell me where the database character set is defined? ... there is no SQL Server 2003. ... The server and database collation mainly serves to set the default collation ...
    (comp.databases.ms-sqlserver)
  • RE: Install SQL Server 2000 with different COLLATION
    ... When you upgrade an existing SQL 7.0 instance, ... always inherits the 7.0 instance's collation. ... If you want to install SQL ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.server)
  • Re: To unicode or not?
    ... Then again, since SQL Server stores Unicode data in the UCS-2 encoding, ... use them with varchar, you simply work with a subset of the characers, ... an SQL collation is just a Windows collation ...
    (comp.databases.ms-sqlserver)
  • Re: changing the SORT Collations
    ... Collation in SQL 2000 is now a per database setting. ... To change the sort order for the ... server, you have to detach all databases, uninstall and reinstall SQL in the ...
    (microsoft.public.sqlserver.server)
  • Re: New bie to SQL, confused about SQL collation
    ... I'm confused about the SQL collation, ... the database collation affects both data and metadata. ... English_Content Nvarchar ...
    (comp.databases.ms-sqlserver)