SQL ????? ??? ??? ???? collation ???? ?? ??? ???? ??????? ?? ?? collation ??????????? ???? ?? ??? ???? ????

?? ???? collation ????????? ???? ?? ?? ?? ???? ??????????? ???? ?? ??? ???? ??????? ?? Microsoft SQL Server ??? ?? collation SQL ????? ??? ??? ???? collation ?? ????? ???? ??? ?? ?? ????????? ?? SQL Server 2000 ?? ???? ??? ????? ?? ???? ???? ?? ??? SQL Server 2005?

???? collation ???

??? collation ???????? ???? ?? ???????????? ???? ???? ??? ???????? ?? ????????? ???? ??? ?? ?? ?????? ?? ????? ???? ?? ??? ?? ?????? ?? ????? ???? ?? ??? ????? ??? ???? ??? ?? ????????? ???? ??? ??? collation ?? ?????????? ????????? ???:

• ????
• ??? ???????????
• ??????? ???????????
• ???? ???????????

???? ????? ??? ????? ?? ??? ?? ?? collation ????? ???, ?? ??? ?? ??? ???? ???sp_helpsort?????? ????????? SQL ?????? ???????? ??? ???

SQL Server 7.0 ?? ??? ?? ?? ???? collations ??????? ?? ?????? ???? ????? ?????, ?? SQL Server 7.0 ??? ??? ??? ??????? ??????? collation ?? ????? ????? SQL Server 2000 ?????? collations ?? ?????? ???? ??? SQL Server 2000 ??????? ??????? collation ?? ????? collations ?? ???? ??? ?? ??? ??, SQL Server 2000 ?? ?????? ????? ??? ?????? collations ??????? ?? ????? collations ???? ?? ???? ?? ???

?? ????? ?? ????? ???? ?? ??? Collation DTS ??? ??????

SQL Server 2000 ??? ?? ?? ???? ??????? ?? ????? ??? ?????? ??????? collation ?? ????? collations ?? ????? ??, ????? ??? ???? ?? ?????? ?? ????Collation ?? ????? ???????? ??????????????? ??? ???????? ?????? (DTS)? ?? ???????Collation ?? ????? ?????????? ??????????? ?? ??? ?? ?? ?????? ?????? ????????? ???? ??? ??? ??? SQL Server 2000 ?? ?? ???????? ?? ??? ???? ??????????? ???? ?? ?? ????? ????????? Collation?????? ??? ??? ?? ??? ??????, ???? ?????? ????? ??? ??? ?? ??? If you do not enable the Use Collation option and the code pages are the same on both instances of SQL Server 2000, a direct data transfer occurs. If the code pages are different, the data from the source code page is translated to the destination code page. However, the translation may not be correct when you transfer the data.

???:The collation is important if the collation is used for the data itself and if a column uses the COLLATE clause. TheUse Collationoption determines whether a code page translation occurs when the data is transferred from one collation to another collation. TheUse Collationoption does not affect whether the COLLATE property of a column definition is set. Therefore, if a source table contains a column that was created with a specific collation by using the COLLATE clause, that collation persists when data is transferred, regardless of whether theUse Collateoption is enabled in the Data Transformation Services Wizard.

Transfer methods that do not change a database's collation

The following methods do not change a database's collation:

• ????? ?? ????????????: ???? ????? collation ?? ?? ????? ?? ??? ????? ???? ???? ?? ?? ????? ???????????? ??????? ?? collation ??? ?????? ???? ?? ?? ???? ????? ?? ???? ??????? ?? ???????????? ????? ??????? collation ?? ?? ??? ??? ???? ???
• ??? ?? reattach: ??? ?? ???? ??????? ?? ?? collation ????? ??? ?? ?? ??? ?? ?? reattach ??????? ?? ???? ????? collation ?? ?? ???? ???? ????? ?? ???, ??????? ?? collation ????????? ???? ????? ??????? ?? collation ?? ?? ??? ??? ???? ???
• ????????? ??????? ???????: ???????? ??? ????????? ??????? ??????? essentially ????? detaching reattaching ?? ?????????? ??????? ?? collation ?? ?? ??? ??? ???? ???
  
  ???:????????? ??????? ??????? SQL Server 2000 ??? ?????? ??? ??? ??, ????? ??????? ??????? SQL Server 7.0 ??? ?????? ???? ???

???? ??????? ?? ???? ????? collation SQL Server 7.0 ??? SQL Server 7.0 ??? ?? collation ?? ??????????

Collation SQL Server 7.0 ??? ??? ??? ?? ?? ?????????? ?? ??? ???? ??????? ?? ????? ?? ??? ?????? ?? ?? ?? ?????? ????? ?? ?????????? ??????? ?? ??? ?????????? ????? ???? ?? ?? DTS ?? bcp ?????? ?? ????? ?? ???? ????????????

SQL Server 7.0 SQL Server 7.0 ?? ??? ?? ?? ?? ??? ????? collation ?? ?? ???? ???????? ?? ?? ??? ?? ?? ???? ???????? ?? ???? ??????? ?? ??????????? ???? ?? ??? ????? ????? ?? ???? ????:

1. ????? ??????? ?? ????? ????
2. ????? SQL Server ?????????? ??????? ????? ??????? ??? ??? ?????????? ?? ??? ????????? ????? ?? ????
3. ??? ???????? ??? ??????? ?? ???? ?? ??????? ???? ?? ??? DTS ?? bcp ?????? ?? ????? ?????
4. SQL ????? ?????????? ??????? ?? ??????? ????? ?? ??? ?? ????? ?? ?????? ????? ?? ?? ?? ??????? ??????
   
   ???:?? ?? ??????? ????? ?? ??? ?? ????? ????, ??????? SQL Server 7.0 ??? ??? ???????? ?? ??? ??? ?? ?? collation ?????
5. ??? ???? ?? ????????? ?? ????? ?? ??? ????? SQL ?????? ???????? ??? 2 ?????? ??????? ??? ??? ?????????? re-create ???? ?? ??? ???
   
   ???:???????? ?? ????? SQL Server 7.0 ??? ??? ???????? ?? ??? ??? ?? ?? collation ?? ??????
6. DTS ?? bcp ?????? ?? ????? ?? ?????? ?????? ??? ???? ???? ?????

SQL Server 2000 ??? ?? collation ???? ?? ??? ???? ??????? ?? SQL Server 7.0 ??? ?? collation ??????????

Collation SQL Server 7.0 ?? SQL Server 2000 ?? ??? ???? ??????? ?? ????? ?? ??? ?? ????? ???? ???????, ?????, ?? ????? ??????? collation ?? ??? ?????? ????? ?? ???? ??????????? ???? ?? ????? ???????, ????, ?? ???? ??? ?? ?? ???? ??????????? SQL Server 7.0 ?? SQL Server 2000 ?? ??? ???????? re-create ???? ?? ??? DTS ?? ????? ?? ???? ???? ???, ?? ?? ????? ???? ????Collation ?? ????? ?????????? DTS ??? ???

???:DTS ?????? ?? ??? ?? ???? SQL Server 2000 ??? ??? ???????? ?? ??? ?????????? ?? ??????????? ???? ?? ??? SQL Server 7.0 ??? ????? ?? ?? ????? ???? ????? SQL Server 2000 ??? ????? ?? ?? ???? ??? SQL Server 7.0 ?? SQL Server 2000 ?? ??? ???? ??????????? ???? ?? ??? DTS ?????? ?? ????? ???? ??????

?? SQL Server 7.0 ??? ?? collation SQL Server 2000 ??? ?? collation ???? ?? ??? ???? ??????? ??????????? ????, ????? ????? ?? ???? ????:

1. ????? ??????? ?? ????? ????
2. ????? SQL Server ?????????? ??????? ????? ??????? ??? ??? ?????????? ?? ??? ????????? ????? ?? ????
3. ??? ????? ?????? ??????? ?? ??????? collation ?? ????? ???? ???? collation ???? ?????? ??, ?? ????????? ?? ??????? ????? ?? ??? ?????? collation ???????? ?????
4. ??????? collation ?? ??? ?????? ????? ?? ?? ?? ??????? ?? ??????
5. ??????? ??? ???????? ?? ??? re-create ???? ?? ??? ?????? ????? ?? ??? 2 ??? ???? ?? ????????? ?? ????? ?? ??? ????? SQL ?????? ???????? ???
   
   ???:?? ???????? ?? ????? ?? ??????? ?? ??? ??? ?? ?? collation ?? ?? ?? ??????? ?? ??? ??? ????? collation ????????? ?????
6. ???? ??????????? ???? ?? ??? DTS ?? bcp ?????? ?? ????? ?????
   
   ???:??? ?? DTS ?? ????? ????? ??????:
   • ????????? ???? ?? ??Collation ?? ????? ?????????? ?? ????? ???? ??? ?? ?? ?? ???? ??????????? SQL Server 7.0 ?? SQL Server 2000 ?? ??? ???
   • ?????????? ?? ??????? collation ?? ??? ?????? ????? ?? ???? ?? ?? ???? ???? ???, ??????? ????? ????????? ?????? ??? ???? ???????????????

SQL Server 2000 ??? ?? ????? collation ???? ?? ??? ???? ??????? ?? SQL Server 2000 ??? ?? collation ??????????

?? SQL Server 2000 ??? ?? collation SQL Server 2000 ??? ?? ????? collation ???? ?? ??? ???? ??????? ??????????? ????, ????? ????? ?? ???? ????:

1. ????? ??????? ?? ????? ????
2. ???, ??? ??? ????? COLLATE ??? ?? ????? ?????
3. ??????? collation ?? ??? ?????? ????? ?? ?? ?? ??????? ?? ??????
4. ??? ??? ????? COLLATE ??? ?? ????? ????, ?????? ????? ?? ??? ???? ??????????? ???? ?? ??? DTS ?? ????? ????? ??? ???? ?? ???, ????? ????????? Collation??? ????? ?? ?????? ???? ?? ??? ?? ?? collation ???? ?? ??? ?????? ??????? ?? ???? ??????????? ???? ?? ??? ??????? ??? ??? ????? ????? COLLATE ??? ?? ???, ????? ????? ?? ???? ????:
   1. (???? ???? ?????????????, triggers, ???????? ?????, ????? ?????, ??????? ?????? ?? ??????) ??? ?????????? ?? ??? ????????? ????? ????? ??? ??, ?? ????????? ???? ?? ?? ????????? ????????? 7.0 ???? ????????????????? ?? COLLATE ??? ?? ????? ?? ??? ?????? ???
      
      ???:?? ?? ????? ???????? ????????? 7.0 ???? ?????????????? ?? ???, ???? collation ?? ??? ????? ??? ??, ??? ?? ?? SQL Server 2000 ?????? (?????? ????-??????? ??????, ???, INSTEAD ?????? ?? ????? ?? ??????????? ????????????? ??? ?????????) ????? ???? ???? ?? ???? ???? ?? ????????? ????? ????
   2. ????????? ?? ????? ?? ??? ?? ?????? ??????? collation ?? ??? ?????????? ????? ?? ??? ?????? ??????? ???
   3. ???? ???? ????? ??????? ?? ??? ??????????? ???? ?? ??? DTS ?? ????? ?????
   4. ???? ??????????? ??????????? ??, ?? ??? ????? ??????? ?? ??? ??????, ????? ?????, ???????? ????? ?? ??????????? ?? ??? ????????? ??????
      
      ???:????? ??????????????SQL ????????? ????? ????????? ????? ???, ????? ??? ?????? ?? ????? ???? ?? ??? ????? ????:
      • <object>???????? ???????? ?? ??? ????</object> CREATE ????? ????
      • <object>???????? ???????? ?? ??? ????</object> ????? ????? ????
   5. ?????? ??????? ?? ?? ??? d ????????? ??????

????? ??????? ?? collation ????????? ????

??? ?? collation ?? ????? ????? ????????????: ??????? ?? ???, ???? ?????? ??????????????????:. ???: ?? ?? ?????????????????? ?? ???, ???? essentially ????? ????????????????:. ?????, ?? ???: ??????? ?? ???? ????? ???? ??????????????????::

• ??????? ??? ?? ??? ????? ????? ????? ?? ??? ????????? ???? ???????????????:. ???: ?? ?? ?????????????????? ?? ???,msdb??????? ????????????? ?? ???: ???? ???? ?????, ???? ?????? ?? ??? ?? ???msdb??????? ??????database before you rebuild the?????????????:. Themsdbdatabase is the system database that is used to store your SQL Server jobs, alerts, operators, and DTS packages. The????database is the template database that is used when you create a new database.
• Because rebuilding the??????database creates a new??????database, you must re-enter the existing login information after you rebuild the?????????????:. Therefore, you must export the login information before you rebuild the?????????????:. After you re-create the??????database, import the login information.????? ??????? ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
  246133  (http://support.microsoft.com/kb/246133/ ) SQL ????? ?? ???????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ??? ???? ????
• ???????msdb??????? rebuilt ?? ?? ?? ???: ?????????????????? ?? ???, ???? ????? ????? ????????? ?? ??? ?????, ?????????? ?? ???????? ?? ??? ?? ???: ??????? ?? ?????????????????:. ??? ??, ???? ?????? ????????? ???? ?? ??? DTS ?? ?????????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
  314546  (http://support.microsoft.com/kb/314546/ ) ??????? ?? SQL Server ??? ??? ???????? ?? ??? ?? ???? ?? ??? ???? ????
• ?????????????????? rebuilt ?? ?? ?? ???: ??????????????????, ?? ???? ??? ?? ??? ?? ??????????????????? ?????? ?? ??? ????, scripted, ?? ?? ???: ??????? ?? ???? ????????????????????:. ???? ?????????????? rebuilt, noted ???????? reapply ???

SQL Server 2000 ??? ????? ??????? ?? collation ????????? ????

???? ???? ?? ?? ????? ?? collation????????????? ?? ???, ????? ????? ?? ???? ????:

1. ?? ?? ????? ??????? ?? ???: ?????, ??? ???? ???????? ??? ?? ??? ???? ?? ???? ??????? rebuilt ???? ?? ??? ???????? ?????, ??? ??????? ?? ???? ????? ?? ???????????? ???? ?? ????? ?? ??????? ????? ?? ??? ?? ???, ??? ?? ?? ???? ??? reattach ??????? ?? ????? ??sp_attach_db?????? ????????? ???????? ??? ????????? ???? ?? ???? ??? ??????? ??????? ?? ???: ??????? ???? ?? ???? reattach ???? ?? ??? ??? ?????? ????????????????????:. ?? ???? ??? ???? ??????? ?? ???sp_attach_db?????? ???????? ????????? ?? ???, ????? MSDN ??? ???? ?? ????:
   (SQL.80) http://msdn2.Microsoft.com/en-us/library/aa259611 .aspx (http://msdn2.microsoft.com/en-us/library/aa259611(SQL.80).aspx)
2. ???: ?? ?? ??????????????????, ?? ???? collation????????????? ?? ???,???????????, ??msdb??????? ???? ??? ??? ?????????? ??????? ?? collation ???? ???? ??? ??? ??????? ?????????? ??????? ?? collation ????????? ???? ?? ??? ?? ??????? collation ?? ??? ?? ?? ??????? ????? ?? ???, ??????? ??????? ' ???? ?? ????? ????, ?? ?? ????? DTS ?? bcp ?????? ?? ?? ??????? ??? ???? ??????????? ???? ?? ????
   
   ???:??? ?? ???????? ??????? ???? ?? ????? SQL Server 2000 ??? ???? ??????? ?? collation ????????? ???? ?? ???, ?????? ??? ??????? ?? collation ?? ???????? ??? ?? ????????? ???? ??? ????? collation ?? ????? ?? ??? ?????? ???????? ???? ?? ????? ???????? ???? ?? ????? ????? ??? ?? DTS ?? ????? ?? ??? ???, ??? ???? ??? ?????? ?? ????? ??????? collation ?? ??? ???? ??????????? ???? ?? ?? ????? ???? ?? ????Collation ?? ????? ??????????? ??? ?? DTS ?? ????? ?? ??? ???, ?? ?????? ???? ?? ?? ??????? collation ?? ??? ????? ??, ?? ????????? ???? ?? ????? ???? ?? ????????? ???????? ???? ????? ?????????? ???? ?????? ?? ??????

??? SQL Server 7.0 ????? ??????? ?? collation ????????? ????

???? ???? ?? ?? ????? ?? collation????????????? ?? ???, ????? ????? ?? ???? ????:

1. SQL Server 7.0 ?? ?????? ???? ???? ?? ????? ??????? collation collations ??????? ????? ???: ?????, before ?? ??????????????????, ?????????? ??????? ?? ??? ???? ?? ??????? ?????
2. ??????? ??? ??? ?????????? ?? ??? ????????? ????? ?????
3. Re-create????????????? ?? ??????? collation ???
4. ?? ??????? ?????? ?? ??????? ?? ?? ???????? collation ?? ???????? ??? ?? ???? ???? ????
5. ?????????? ?? re-create ???? ?? ??? ???? ?? ????? ?? ????????? ?????, ?? ?? ???? ???? ??????? ???? ???? ?????

Collations ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:

• (SQL.80) http://msdn2.Microsoft.com/en-us/library/aa214408 .aspx (http://msdn2.microsoft.com/en-us/library/aa214408(SQL.80).aspx)
• (SQL.80) http://msdn2.Microsoft.com/en-us/library/aa174903 .aspx (http://msdn2.microsoft.com/en-us/library/aa174903(SQL.80).aspx)
• (SQL.80) http://msdn2.Microsoft.com/en-us/library/aa258237 .aspx (http://msdn2.microsoft.com/en-us/library/aa258237(SQL.80).aspx)