FreeTDS Development Group

["Brug, Herco van -Syntegra NL" <H.vanBrug AT syntegra.nl>]

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

well my access tells me the proj_toel and proj_antwoord fields are or type memo and as far as i can figure they're 16 textfields long. point is that when i query them i only get the first 255 bytes from them. now 16x255byte is about 4KB which may well be the limit of those memofields but i think freetds somewhere believes they are indeed textfields and returns only 255 byte.

i do think that we're getting closer to the problem

-----Original Message-----
From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
Sent: maandag 13 november 2000 16:53
To: TDS Development Group
Subject: [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)

---
You are currently subscribed to freetds as: [H.vanBrug AT syntegra.nl]
To unsubscribe, forward this message to $subst('Email.Unsub')

-----------------------------

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

-----------------------------

Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder Syntegra goederen en diensten levert zijn met uitsluiting van alle andere voorwaarden onze algemene voorwaarden van toepassing. Deze worden u op aanvraag direct kosteloos toegezonden. Tevens kunt u deze vinden via onze homepage http://www.syntegra.nl

-----------------------------

On all offers and agreements under which Syntegra supplies goods or services of whatever nature, the general terms and conditions from Syntegra Groep B.V. exclusively apply. The general terms and conditions shall be promptly submitted to you on your request. You can also find these via our homepage http://www.syntegra.nl

-----------------------------