tds_fdw icon indicating copy to clipboard operation
tds_fdw copied to clipboard

nvarchar(4000) gets truncated to varchar(255)

Open sdomi opened this issue 5 years ago • 1 comments

Latest version, I'm connected to MS SQL Server 14.0.2027.2 on Windows Server 2016 Standard; I'm connecting from Postgres 11.7 on Debian.

SELECT LENGTH(a_long_column) FROM dbo.asdf;

The above returns string lengths - those are way above 2000 when viewed in MSSQL, but they're all truncated to 255 in postgres.

sdomi avatar Jul 14 '20 14:07 sdomi

Geoff Montee - Is this fixed in new release?

calsql avatar Mar 29 '22 21:03 calsql