Home Dashboard Directory Help
Search

data truncation on varchar(max) column through linked server by spaghettidba


Status: 

Active


9
0
Sign in
to vote
Type: Bug
ID: 811840
Opened: 12/17/2013 3:34:06 PM
Access Restriction: Public
0
Workaround(s)
view
4
User(s) can reproduce this bug

Description

When inserting data through a linked server to a varchar(max) column with a non default collation, data gets truncated randomly at around 30 characters.
The same thing does not happen with:
* non MAX varchars columns
* text columns
* nvarchar(max) columns
Changing the collation of the column to the default database collation fixes.

The repro script uses a loopback linked server, but the same results are returned with a real linked server.

Many collations are affected by the issue. I have a script that tests the behavior with all possible collations: 545 of them fail, 178 work.

I also tested different providers, including OLEDB and SQLNCLI. The same behavior was observed.
Changing the linked server's options that deal with collation does not affect the results.
Details
Sign in to post a comment.
Posted by Microsoft on 2/18/2014 at 2:20 PM
Dear Customer,

Since OLEDB is deprecated, the only fix for this issue is through Hotfix. Please contact our customer service department to do a further escalation.

Thanks
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
TestAllCollations.sql 12/17/2013 2 KB
MaxRepro_UNICODE.sql 12/17/2013 2 KB
MaxRepro.sql 12/17/2013 2 KB