Re: [sqlalchemy] MemoryError in VSCode using dtype NVARCHAR(None) for SQL Server NVARCHAR(max)

This is nothing to do with SQLAlchemy directly but take a look at https://github.com/sqlalchemy/sqlalchemy/issues/5334 for a common situation that leads to this issue. On Thu, Nov 12, 2020, at 9:18 PM, J Sherwood wrote: > Hello, > > I am moving an Oracle Database to SQL Server. > > I go

[sqlalchemy] MemoryError in VSCode using dtype NVARCHAR(None) for SQL Server NVARCHAR(max)

Hello, I am moving an Oracle Database to SQL Server. I go through the table columns and create a dictionary of columnName: sqlalchemy.types. and then push them to SQL Server using df.to_sql. Most tables work fine except when I have a large VARCHAR2 from Oracle of 8000+ I need it to become a