SqlServer text size limitation

Sasha Dolgy sdolgy at birdonawire.com
Thu Mar 29 12:29:05 EST 2001


varchar only goes up to 255 if i remember.  if you're going bigger, use text
or something to that effect...in mysql it is tinytext,mediumtext,longtext

-sasha

-----Original Message-----
From: Rodolphe Ode [mailto:rodolphe.ode at eolas.fr]
Sent: Thursday, March 29, 2001 11:56 AM
To: TDS Development Group
Subject: [freetds] SqlServer text size limitation


Hi !

I got a trouble with SQLServer that I query with PHP (Linux) through
FreeTDS. Actually, I got some bunch of text fields (VARCHAR) that may
contain up to 4000 character, but as I select this fields in an SQL query,
only the first 255 characters are given back to PHP. Is there anyone who
has/had the same trouble ?

Thanks a lot,

Rodolphe
---
You are currently subscribed to freetds as: [sdolgy at birdonawire.com]
To unsubscribe, forward this message to
$subst('Email.Unsub') 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20010329/cd1be016/attachment.html 


More information about the FreeTDS mailing list