Skip to Content.
Sympa Menu

freetds - Re: [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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: Matt Grimm <matt.t.grimm+freetds AT gmail.com>
  • Subject: Re: [freetds] nvarchar(max) field in result set identified as WVARCHAR, not WLONGVARCHAR
  • Date: Sun, 1 Feb 2015 10:07:03 +0000

2014-09-24 21:28 GMT+01:00 Matt Grimm <matt.t.grimm+freetds AT gmail.com>:
> 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.
>


Hi,
probably it should but actually is the same reply I get from MS ODBC.

Frediano



  • Re: [freetds] nvarchar(max) field in result set identified as WVARCHAR, not WLONGVARCHAR, Frediano Ziglio, 02/01/2015

Archive powered by MHonArc 2.6.24.

Top of Page