FreeTDS Development Group

["Jason Lane" <kbdrand AT hotmail.com>]

I mean the actual field type of 'Memo'. Yes it's just a large text field
but it's listed as a 'Memo' type. I found the answer anyway. I'm just
using CAST to set it to a varchar(8000) and that seems to fix it.


-----Original Message-----
From: bounce-freetds-144831 AT franklin.oit.unc.edu
[mailto:bounce-freetds-144831 AT franklin.oit.unc.edu] On Behalf Of Brian
Bruns
Sent: Thursday, August 08, 2002 1:56 PM
To: TDS Development Group
Subject: [freetds] Re: Ok, I know I heard about memo fields before...


By memo fields, I presume you mean the 'text' datatype which several MS 
products (most notably Access) refer to incorrectly.  If so just set the

'text size' option in the freetds.conf file to something reasonable or 
issue the query 'set textsize xxx' where xxx is some reasonable size in 
bytesy.

Brian

On Thu, 8 Aug 2002, KBDRand wrote:

> I can't seem to find where it talks about Memo fields, but I thought
there
> was a problem pulling them in before. I have a number of tables with
'Memo'
> fields. As long as I don't try to retrieve the Memo fields everything
works
> fine. As soon as I try to get a memo field the connection fails (or
> something in the process).
> 
> I'm running SQL Server 7.0 on the Windows side and Linux Redhat 7.3
with
> Freetds .5x (I think it's .53) or so on the Linux side. I'm using PHP
4.2.1
> to do the actual queries.
> 
> Anyone know the solution?
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
> 
> 


---
You are currently subscribed to freetds as: [kbdrand AT hotmail.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')