Django MsSQL FreeTDS - Nvarchar(max) Auto Truncates

Question

I'm using Django that is connected to AWS' RDS MSSQL. So I'm to input very long texts, but they are generally longer than 4000 characters. In Django, this specific field is using TextField and the data type in MSSQL is nvarchar(max). So my question now is how can I configure and increase its max length. I've got the assumption that it's supposed to be infinite (of course it's not).

Help is desperately needed. I've read about it briefly here: How to get entire VARCHAR(MAX) column with Python pypyodbc. However, I'm using RDS and I have no idea in doing this as at all.

Thank you all in advanced!

Did you try the freetds specific solution in the SO question that you linked to? — Ben Thul, Jan 27 '18 at 13:40

score 0 · Answer 1 · answered Jul 19 '18 at 08:25

0

If you are using django-pyodbc-azure, upgrading from 1.11.11.0 to 1.11.13.1 fixed the issue for me.

answered Jul 19 '18 at 08:25

Richard Pryce

128
6

Django MsSQL FreeTDS - Nvarchar(max) Auto Truncates

1 Answers1