Unable to Bulk Insert with NVARCHAR(MAX) Column

[calebbriggs]

Problem I am having is that we already have a full schema setup and have quite a few columns that are NVARCHAR(MAX) in the database.

When doing a bulk insert into one of these tables we get the following error:

{ name: 'RequestError',
     message: 'Unicode data is odd byte size for column 9. Should be even byte size.',
     code: 'EREQUEST',
     precedingErrors: [] },
  refresh: false }

For testing, If we run an alter script to change the column to NVARCHAR(3999) and modify the bulk insert code accordingly, everything goes through just fine. However, altering all of these columns is not an option.

Any ideas or suggestions?

[bretcope]

I'll look into this when I get a chance unless another maintainer beats me to it.

[bretcope]

I'm going to track this here: tediousjs/tedious#197

[patriksimek]

Thanks @bretcope, closing this one.

[bretcope]

@calebbriggs sorry for the delay in figuring out the problem. I've pushed a fix to Tedious which makes Bulk Load work for me with nvarchar(max). Can you update your Tedious dependency to 1.5.4 and verify that your problem has disappeared as well?

[calebbriggs]

@bretcope updated my mssql and ran my tests. All are passing now with flying colors. Appreciate the help.

[calebbriggs]

@bretcope are your tests still passing on this we were using a number larger than 4000
NVarchar(5000) . It says we can no longer exceed max length so we tried NVarchar('Max')
which did not work either.

[bretcope]

What do you mean by "did not work"? That's essentially nothing to go on. There probably should be a test for nvarchar(max) in Tedious. If you run the repro script I put in the related Tedious issue, and it works, then it's not a Tedious problem. If it doesn't, then post the results and I'll take a look at it.