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