Skip to Content.
Sympa Menu

freetds - Re: Ok, I know I heard about memo fields before...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Jason Lane" <kbdrand AT hotmail.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Ok, I know I heard about memo fields before...
  • Date: Thu, 8 Aug 2002 18:50:43 -0500


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




Archive powered by MHonArc 2.6.24.

Top of Page