Comments by peskandritsa2 (Top 2 by date)

peskandritsa2 7-Dec-17 8:42am View

I meant to reply @ Balboos. From what I've found out nvarchar(MAX) sotres up to 4000 chars. In order to store more than that, it uses a different page on the sql server. (This came straight from a Microsoft MVP specializing in SQL server) Unfortunately it seems that when using SqlBulkCopy, this is not the case. I don't know how to overcome this.

peskandritsa2 6-Dec-17 15:19pm View

The Database column is already set as NVarchar(MAX) ...the problem is that the string will not get copied in the column and the program will throw an exception...
string type on the code, NVarchar(MAX) type on the database. Could you be a bit more specific please regarding the previous answers ?