nvarchar(4000) gets truncated to varchar(255)

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)

Other

377 stars 101 forks source link

Open sdomi opened 4 years ago

sdomi commented 4 years ago

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.

calsql commented 2 years ago

Geoff Montee - Is this fixed in new release?