Skip to Content.
Sympa Menu

freetds - [freetds] nvarchar(max) field in result set identified as WVARCHAR, not WLONGVARCHAR

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Matt Grimm <matt.t.grimm+freetds AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] nvarchar(max) field in result set identified as WVARCHAR, not WLONGVARCHAR
  • Date: Wed, 24 Sep 2014 14:28:42 -0600

Hi,

When I use SQLColAttributeW(... SQL_DESC_CONCISE_TYPE ...) to ask FreeTDS
for the type of an nvarchar(max) column in my result set, it calls it a
SQL_WVARCHAR (-9). However, when I ask it for the type of an ntext field,
it calls it a SQL_WLONGVARCHAR. Since nvarchar(max) is the replacement for
ntext[1], shouldn't FreeTDS return -10 as the type of nvarchar(max) too?

Thanks,
m.

[1] http://msdn.microsoft.com/en-us/library/ms178158.aspx;
http://msdn.microsoft.com/en-us/library/ms187993.aspx



  • [freetds] nvarchar(max) field in result set identified as WVARCHAR, not WLONGVARCHAR, Matt Grimm, 09/24/2014

Archive powered by MHonArc 2.6.24.

Top of Page