nvarchar(max) field in result set identified as WVARCHAR, not WLONGVARCHAR

Matt Grimm <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAG4_kQu8Fu2_3uBpwEg=yLAD2eV1Ekp6r8grcWHJxcjoO2RPyQ@mail.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.

[1] http://msdn.microsoft.com/en-us/library/ms178158.aspx;
http://msdn.microsoft.com/en-us/library/ms187993.aspx
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.