Open gizmo93 opened 4 years ago
If I'm understanding correctly, you're reporting the behavior documented here: https://zillow.github.io/ctds/bulk_insert.html#text-columns
As far as I know, this is a deficiency in FreeTDS' implementation of BUILK INSERT
Hey, there are no problems with "normal" VARCHAR/NVARCHAR columns, they work as expected, if I wrap them in ctds.VarChar(). Problem seems to be only when trying to BULK INSERT into a VARCHAR/NVARCHAR (MAX) column. Is there any solution / workaround for this?
Avoid varchar/nvarchar (max). Use ntext instead.
When trying to bulk insert a String into a VARCHAR(MAX), NVARCHAR(MAX) field, we get this error message.
CTDS version: 1.11.0 FreeTDS version: 1.00.80 Python 3.7 Windows 10 64 bit
Example:
Code to reproduce (sorry, really had problems to get the code properly formatted inside the Github Editor) test.txt