I wish to remain ignorant of MS SQL Server, but when I see "right truncation" that looks like someone dropping data off of "the right end" of the field - ie truncating your string short. That might be in the database or driver, I don't know, but try running some tests and find what length that cutoff happens at.