FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

Title: RE: [freetds] Re: 255 char limit in result queries

Herco,

You have more information than you think.  You're right, syscolumns is no longer documented by Microsoft (that I could find), but the systypes table tells you what you want to know:

select
  cast( name as varchar(17) ) as name
, usertype
, type
, xtype
, xusertype
, length
, allownulls as 'Null'
from systypes

name              usertype type xtype xusertype length Null
----------------- -------- ---- ----- --------- ------ ----
binary                   3   45   173       173   8000    1
bit                     16   50   104       104      1    1
char                     1   47   175       175   8000    1
datetime                12   61    61        61      8    1
decimal                 24   55   106       106     17    1
float                    8   62    62        62      8    1
image                   20   34    34        34     16    1
int                      7   56    56        56      4    1
money                   11   60    60        60      8    1
nchar                    0   47   239       239   8000    1
ntext                    0   35    99        99     16    1
numeric                 10   63   108       108     17    1
nvarchar                 0   39   231       231   8000    1
real                    23   59    59        59      4    1
smalldatetime           22   58    58        58      4    1
smallint                 6   52    52        52      2    1
smallmoney              21  122   122       122      4    1
sysname                 18   39   231       256    256    0
text                    19   35    35        35     16    1
timestamp               80   45   189       189      8    0
tinyint                  5   48    48        48      1    1
uniqueidentifier         0   36    36        36     16    1
varbinary                4   37   165       165   8000    1
varchar                  2   39   167       167   8000    1

(24 row(s) affected)

It looks to me that "Proj_toel" and "Proj_antwoord" are of type text.  The dates (e.g., Proj_mdatum) are of some user-defined type (111), though, the name of which you'll see if you run the above query on your server. 

--jkl

-----Original Message-----
From: Brug, Herco van -Syntegra NL [mailto:H.vanBrug AT syntegra.nl]
Sent: November 13, 2000 6:07 AM
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries

i couldnt find the type 35 data types in my sql docs (nor the 38 or 39 so i probably dont have the complete docs)