数据自动截断nvarchar的值.. [英] Data is automatically truncating value for nvarchar..
问题描述
今天我有一个疲惫的问题。
我已经将列数据类型varchar(2000)更新为nvarchar(MAX)
喜欢这个..
ALTER TABLE catalog_seo
ALTER COLUMN vc_bottom_content nvarchar (MAX)不 null
在此之前,此列仅限于2000个字符。我得到的问题仍然是数据没有保存超过2000个字符。
我的意思是如果我尝试插入2500个字符,它会默默地删除最后500个字符。
请帮我这个..
Thnxx提前。
< blockquote>我发现了这个问题的原因实际上程序的参数被设置为2000作为eirler。
我忘了改变它。 @vc_bottom_content varchar(2000)='',
我将其更改为@vc_bottom_content nvarchar(MAX)=''
工作..
谢谢PIEBALDconsult
Today i am having a wearied issue.
I have updated a column datatype varchar(2000) to nvarchar(MAX)
like this ..
ALTER TABLE catalog_seo
ALTER COLUMN vc_bottom_content nvarchar(MAX) not null
Before that this column was restricted for 2000 char. The issue i am getting that still data is not being saved for greater then 2000 char.
I mean if i try to insert 2500 character it silently remove last 500 char.
Please help me on this ..
Thnxx in advance.
I found the cause of this issue Actually parameter of procedure was set to 2000 as eirler.
I forgot to change this. @vc_bottom_content varchar(2000) = '',
I changed it to @vc_bottom_content nvarchar(MAX) = ''
It worked..
Thanks PIEBALDconsult
这篇关于数据自动截断nvarchar的值..的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!