更改数据库的排序规则属性时出现的问题 [英] issue while changing the collation property of database
问题描述
我想将数据库的排序规则属性从sql_Latin1_General_CP1_CI_AS更改为"Latin1_General_CS_AS_WS".我正在从数据库属性选项中进行操作.
但是在将归类更改为由于数据库中的列和函数取决于数据库归类而无法更改归类"时出现错误，它显示了数据库归类所依赖的所有列和函数的列表.
有什么方法可以更改数据库排序规则以及列和函数的排序规则.
Hi,
i Want to change the collation property of database as "Latin1_General_CS_AS_WS" from sql_Latin1_General_CP1_CI_AS. I am doing it from options of database property.
But i am getting error while changing the collation as "Can not change the collation because Columns and functions in the database are dependent on the database collation" and it shows lists of all columns and functions on which database collation depends.
Is there any way of changing database collation as well as collation of columns and functions.
推荐答案
您必须将数据库中的所有对象更改为所需的排序规则，然后更改数据库排序规则..
检查一下.
http://blogs.microsoft. co.il/blogs/yehudala/archive/2012/01/08/sql-server-database-collation-summary.aspx [
You have to alter all the objects in the database to the collation you want then alter db collation..
Check this.
http://blogs.microsoft.co.il/blogs/yehudala/archive/2012/01/08/sql-server-database-collation-summary.aspx[^]
As he said you have to replace
1. TAble column
2. Index Column
3. Any Constraint Column
4. Function Table Column
5. Full Text
这篇关于更改数据库的排序规则属性时出现的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
