Skip to Content.
Sympa Menu

freetds - [freetds] varbinary(MAX) and DBCOL.MaxLength

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: LacaK <lacak AT zoznam.sk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] varbinary(MAX) and DBCOL.MaxLength
  • Date: Mon, 02 Mar 2015 07:51:19 +0100

Hi *,
I have table with columns with these types:
XML,
varchar(MAX),
nvarchar(MAX),
varbinary(MAX)
When I use dbtablecolinfo() I receive DBCOL structure with these MaxLength (or dbcollen()):
2147483647 (=2^31-1)
2147483647
2147483647
1073741823 (=2^30-1)
I am wondering about varbinary(MAX), I would expect 2147483647 for them also.
(as SQL Server documentation says, that maximum storage size is 2^31-1 bytes)
Why is there 2^30-1 , is it okay?

Thanks
-Laco.

Here is part of tds dump:

token.c:1537:tds7_get_data_info:
colname = xml_field
type = 241 (xml)
server's type = 241 (xml)
column_varint_size = 8
column_size = 2147483647 (2147483647 on server)

token.c:3148:adjust_character_column_size:
Server charset: CP1250
Server column_size: 1073741823
Client charset: UTF-8
Client column_size: 2147483647
token.c:1537:tds7_get_data_info:
colname = varcharmax_field
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 8
column_size = 2147483647 (1073741823 on server)

token.c:3148:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 1073741823
Client charset: UTF-8
Client column_size: 2147483647
token.c:1537:tds7_get_data_info:
colname = nvarcharmax_field
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 8
column_size = 2147483647 (1073741823 on server)

token.c:1537:tds7_get_data_info:
colname = varbinarymax_field
type = 37 (varbinary)
server's type = 165 (xvarbinary)
column_varint_size = 8
column_size = 1073741823 (1073741823 on server)

token.c:1609: name size/wsize type/wtype utype
token.c:1610: -------------------- --------------- --------------- -------
token.c:1615: xml_field 2147483647/2147483647 241/241 0
token.c:1615: varcharmax_field 2147483647/1073741823 39/167 0
token.c:1615: nvarcharmax_field 2147483647/1073741823 39/231 0
token.c:1615: varbinarymax_field 1073741823/1073741823 37/165 0




Archive powered by MHonArc 2.6.24.

Top of Page