Re: Testing 0.95: What TDS version for SQL Server 2012 / 2014?

LacaK <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
>>>          colname = t
>>>          type = 39 (varchar)
>>>          server's type = 167 (xvarchar)
>>>          column_varint_size = 8
>>>          column_size = 1073741823 (1073741823 on server)
>>>
>>> ...
>>>
>>
>> Please try SQLDescribeCol. Libtds have slightly different point of view.
>> As stated from Ms documentation varchar max is returned as varchar with
>> size 0 (unlimited). Same for freetds.
>
> ??? I am confused... of course using SQLDescribeCol(), I just copied
> lines from TDSDUMP...
>
> Why can I see:
>
>      column_size = 1073741823 (1073741823 on server)
>
> Remember: I am using SQL Server 2014... did you try with SQL Server 2014?
>
It is my experience with dblib also. That varchar(MAX) returns for 
column size "big number", not 0
(I thought that it is as expected)
-Laco.
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.