Skip to Content.
Sympa Menu

freetds - Re: Retrieve >255 chars

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Ilya Storozhilov" <storozhilov AT newmail.ru>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Retrieve >255 chars
  • Date: Wed, 3 Jan 2001 14:14:36 +0300


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.






Archive powered by MHonArc 2.6.24.

Top of Page