freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: SqlServer text size limitation

From: Sasha Dolgy <sdolgy AT birdonawire.com>
To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
Subject: RE: SqlServer text size limitation
Date: Thu, 29 Mar 2001 12:29:05 -0500

Title: RE: [freetds] SqlServer text size limitation

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')

SqlServer text size limitation, Rodolphe Ode, 03/29/2001
- <Possible follow-up(s)>
- RE: SqlServer text size limitation, Sasha Dolgy, 03/29/2001
- RE: SqlServer text size limitation, Bob Kline, 03/29/2001
- Re: SqlServer text size limitation, Brian Bruns, 03/29/2001
- Re: SqlServer text size limitation, Guille -bisho-, 03/30/2001
- Re: SqlServer text size limitation, Eric Deutsch, 03/30/2001