Microsoft SQL Server 2012和.Net Framework2012 [英] Microsoft SQL Server 2012 and .Net Framework2012
问题描述
大家好,
请帮帮我。
我执行时遇到此错误Aspnet_regsql.exe:
执行SQL文件'InstallMembership.sql'时发生错误。 SQL错误号为4188,SqlException消息为:列或参数'@Comment'的类型为'ntext',排序规则为'Persian_100_CS_AS_KS_WS_SC'。传统LOB类型不支持代码点为U + 10000或更高的Unicode补充字符。将列或参数类型更改为varchar(max),nvarchar(max)或使用没有_SC标志的排序规则。
什么是解决方案?请帮助我。
Hi all,
Please help me.
I got this error when I am execute Aspnet_regsql.exe:
An error occurred during the execution of the SQL file 'InstallMembership.sql'. The SQL error number is 4188 and the SqlException message is: Column or parameter '@Comment' has type 'ntext' and collation 'Persian_100_CS_AS_KS_WS_SC'. The legacy LOB types do not support Unicode supplementary characters whose codepoints are U+10000 or greater. Change the column or parameter type to varchar(max), nvarchar(max) or use a collation which does not have the _SC flag.
what is solution? please help me.
推荐答案
正如ThePhantomUpvoter所提到的,解决方案是:将列或参数类型更改为nvarchar(max)或使用collation没有_SC标志
设置或更改数据库归类(T-SQL) [ ^ ]
设置或更改列整理 [ ^ ]
数据类型(T-SQL) [ ^ ]
ALTER TABLE(T-SQL) [ ^ ]
As ThePhantomUpvoter has mentioned, the solution is:Change the column or parameter type to nvarchar(max) or use a collation which does not have the _SC flag
Set or Change The Database Collation (T-SQL)[^]
Set or Change the Column Collation[^]
Data types (T-SQL)[^]
ALTER TABLE (T-SQL)[^]
这篇关于Microsoft SQL Server 2012和.Net Framework2012的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!