Skip to Content.
Sympa Menu

freetds - Re: Retrieve >255 chars

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Daniel Selin" <daniel.selin AT home.se>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Retrieve >255 chars
  • Date: Wed, 3 Jan 2001 13:40:24 +0100


It worked just fine, just received 389 chars! CAST(field AS TEXT) did the
trick.
Thank you very much.

/Daniel

-----Original Message-----
From: bounce-freetds-122119 AT franklin.oit.unc.edu
[mailto:bounce-freetds-122119 AT franklin.oit.unc.edu]On Behalf Of Ilya
Storozhilov
Sent: den 3 januari 2001 12:15
To: TDS Development Group
Subject: [freetds] Re: Retrieve >255 chars


Use this syntax (here is an example):

CREATE TABLE CLIENTS (
CLIENTS_ID INT,
CLIENTS_FULLNAME VARCHAR(250),
CLIENTS_DESCRIPTION VARCHAR(2000))

...

SELECT
CLIENTS_ID,
CLIENTS_FULLNAME
CAST(CLIENTS_DESCRIPTION AS TEXT) CLIENTS_DESCRIPTION
FROM CLIENTS
WHERE CLIENTS_ID = 1234

in SELECT statement for retriving more than 255 characters.


> I got the same problem, can't get more than 255 chars from a SELECT
although
> the record contains more than that in the DB. (INSERT seems to work with
> >255 chars)
> I would really appreciate if someone could fix this problem.
>
> I'm using the 2.0 Snapshot-Jar with MSSQL7 BTW.
>
> Thanks.



---
You are currently subscribed to freetds as: [daniel.selin AT home.se]
To unsubscribe, forward this message to
$subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page