Matt Grimm
2014-09-24 20:28:42 UTC
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
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