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.
ThanksSelect "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: "examnotes" <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
|
||||Hi Bart,
I select "Binary order, for use with the 850(Multilingual) character set"
sp_helpsort on sql 2000 gives following:
Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 40 on
Code Page 850 for non-Unicode Data
Whereas in sql 7 installation it gives:
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
What I ma missing?
"Bart Duncan [MSFT]" wrote:
> 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: "examnotes" <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
> |
> |
>|||sp_helpsort formats its output differently on the two versions.
Every collation specifies three things: (1) the sorting rules to use for
Unicode data, (2) the code page to use for non-Unicode data, and (3) the
sort order to use for non-Unicode data. Per your 7.0 sp_helpsort output
your 7.0 collation has the following properties:
1. Unicode sort = binary ("locale 33280" is binary)
2. Non-Unicode code page = 850
3. Non-Unicode sort order = 40
Your 2000 server has the same collation properties.
Try the backup and restore. Then run "sp_helpdb" to find the collation
name of the upgraded database, and SELECT SERVERPROPERTY('Collation') to
find the SQL 2000 server's collation name. They should be the same. If
they are not the same, reply back with the database's and SQL 2000 server's
collation names.
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: Collation
| thread-index: AcSWm3Hjx0LhTQwxScuh1HZyoGdqpA==
| X-WBNR-Posting-Host: 199.20.71.17
| From: "examnotes" <SB138@.discussions.microsoft.com>
| References: <453BEDBF-EFD3-4F90-B477-547692531EB2@.microsoft.com>
<o8n2qv4iEHA.2968@.cpmsftngxa10.phx.gbl>
| Subject: RE: Collation
| Date: Thu, 9 Sep 2004 11:33:04 -0700
| Lines: 73
| Message-ID: <9FCF40ED-A3BB-4935-8486-DADDF4E04F61@.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:358302
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi Bart,
| I select "Binary order, for use with the 850(Multilingual) character set"
| sp_helpsort on sql 2000 gives following:
| Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 40 on
| Code Page 850 for non-Unicode Data
|
| Whereas in sql 7 installation it gives:
| 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
| What I ma missing?
|
| "Bart Duncan [MSFT]" wrote:
|
| > 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: "examnotes" <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
| > |
| > |
| >
| >
||||Thanks for clarifying.
How I can find out what locale_id in 2K, and is it case sensitive or
insensitive? I just want to be sure that collation settings on 2000 are same
as 7 before I restore sql 7 backup onto sql 2K.
"Bart Duncan [MSFT]" wrote:
> sp_helpsort formats its output differently on the two versions.
> Every collation specifies three things: (1) the sorting rules to use for
> Unicode data, (2) the code page to use for non-Unicode data, and (3) the
> sort order to use for non-Unicode data. Per your 7.0 sp_helpsort output
> your 7.0 collation has the following properties:
> 1. Unicode sort = binary ("locale 33280" is binary)
> 2. Non-Unicode code page = 850
> 3. Non-Unicode sort order = 40
> Your 2000 server has the same collation properties.
> Try the backup and restore. Then run "sp_helpdb" to find the collation
> name of the upgraded database, and SELECT SERVERPROPERTY('Collation') to
> find the SQL 2000 server's collation name. They should be the same. If
> they are not the same, reply back with the database's and SQL 2000 server'
s
> collation names.
> 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: Collation
> | thread-index: AcSWm3Hjx0LhTQwxScuh1HZyoGdqpA==
> | X-WBNR-Posting-Host: 199.20.71.17
> | From: "examnotes" <SB138@.discussions.microsoft.com>
> | References: <453BEDBF-EFD3-4F90-B477-547692531EB2@.microsoft.com>
> <o8n2qv4iEHA.2968@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Collation
> | Date: Thu, 9 Sep 2004 11:33:04 -0700
> | Lines: 73
> | Message-ID: <9FCF40ED-A3BB-4935-8486-DADDF4E04F61@.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:358302
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Hi Bart,
> | I select "Binary order, for use with the 850(Multilingual) character se
t"
> | sp_helpsort on sql 2000 gives following:
> | Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 40 o
n
> | Code Page 850 for non-Unicode Data
> |
> | Whereas in sql 7 installation it gives:
> | 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
> | What I ma missing?
> |
> | "Bart Duncan [MSFT]" wrote:
> |
> | > 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: "examnotes" <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
> | > |
> | > |
> | >
> | >
> |
>|||SQL 7.0 lets you indepently specify different values for the three
properties of a collation. If you really want to you can set up a 7.0
server with totally inconsistent collation settings (for example, binary
non-Unicode sort order, Japanese non-Unicode code page, Greek case
insensitive Unicode sorting). In SQL 2000, though, the three collation
properties are no longer independently configurable; you just specify a
single collation, and that collation name implicitly determines the three
collation properties (Unicode sorting, non-Unicode sorting + non-Unicode
code page). The reason for this change in SQL 2000 is to try to ensure
that the handling of non-Unicode data and Unicode data are as consistent as
possible.
One side effect of this change is that SQL 2000's sp_helpsort output does
not report the three properties independently, in the same way that 7.0
does. In the 7.0 sp_helpsort output, Unicode sorting (this is called
"locale ID" in the 7.0 sp_helpsort) is identified explicitly by a specific
number, but in SQL 2000 this setting is only implied by the collation
identifier. In the 7.0 Books Online topic "Unicode Collation" you'll find
a list of locale IDs. This will tell you that 33280 is the binary Unicode
locale, which should be equivalent to "binary sort for Unicode Data" in the
SQL 2000 sp_helpsort output.
If you're thinking that this is a lot of trouble to go through just to
figure out what SQL 2000 setup settings you need to select to get a server
with the same collation settings as your 7.0 server, I agree; it's
unfortunately more complex than it could be. For what it's worth, there
have been some attempts to make improvements in this area in Yukon setup.
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: AcSZnOYevuO9yaKqSoifBdvA0OJFLQ==
| X-WBNR-Posting-Host: 199.20.71.17
| From: "examnotes" <SB138@.discussions.microsoft.com>
| References: <453BEDBF-EFD3-4F90-B477-547692531EB2@.microsoft.com>
<o8n2qv4iEHA.2968@.cpmsftngxa10.phx.gbl>
<9FCF40ED-A3BB-4935-8486-DADDF4E04F61@.microsoft.com>
<mrGZsi2lEHA.3608@.cpmsftngxa10.phx.gbl>
| Subject: RE: Collation
| Date: Mon, 13 Sep 2004 07:21:02 -0700
| Lines: 140
| Message-ID: <5BC4C012-F922-40D2-AC4F-0CC17429381B@.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:358661
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Thanks for clarifying.
| How I can find out what locale_id in 2K, and is it case sensitive or
| insensitive? I just want to be sure that collation settings on 2000 are
same
| as 7 before I restore sql 7 backup onto sql 2K.
| "Bart Duncan [MSFT]" wrote:
|
| > sp_helpsort formats its output differently on the two versions.
| >
| > Every collation specifies three things: (1) the sorting rules to use
for
| > Unicode data, (2) the code page to use for non-Unicode data, and (3)
the
| > sort order to use for non-Unicode data. Per your 7.0 sp_helpsort
output
| > your 7.0 collation has the following properties:
| > 1. Unicode sort = binary ("locale 33280" is binary)
| > 2. Non-Unicode code page = 850
| > 3. Non-Unicode sort order = 40
| >
| > Your 2000 server has the same collation properties.
| >
| > Try the backup and restore. Then run "sp_helpdb" to find the collation
| > name of the upgraded database, and SELECT SERVERPROPERTY('Collation')
to
| > find the SQL 2000 server's collation name. They should be the same.
If
| > they are not the same, reply back with the database's and SQL 2000
server's
| > collation names.
| >
| > 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: Collation
| > | thread-index: AcSWm3Hjx0LhTQwxScuh1HZyoGdqpA==
| > | X-WBNR-Posting-Host: 199.20.71.17
| > | From: "examnotes" <SB138@.discussions.microsoft.com>
| > | References: <453BEDBF-EFD3-4F90-B477-547692531EB2@.microsoft.com>
| > <o8n2qv4iEHA.2968@.cpmsftngxa10.phx.gbl>
| > | Subject: RE: Collation
| > | Date: Thu, 9 Sep 2004 11:33:04 -0700
| > | Lines: 73
| > | Message-ID: <9FCF40ED-A3BB-4935-8486-DADDF4E04F61@.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:358302
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | Hi Bart,
| > | I select "Binary order, for use with the 850(Multilingual) character
set"
| > | sp_helpsort on sql 2000 gives following:
| > | Latin1-General, binary sort for Unicode Data, SQL Server Sort Order
40 on
| > | Code Page 850 for non-Unicode Data
| > |
| > | Whereas in sql 7 installation it gives:
| > | 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
| > | What I ma missing?
| > |
| > | "Bart Duncan [MSFT]" wrote:
| > |
| > | > 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: "examnotes" <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
| > | > |
| > | > |
| > | >
| > | >
| > |
| >
| >
|
No comments:
Post a Comment