FreeTDS Development Group

["Daniel Selin" <daniel.selin AT home.se>]

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