freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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.
-
Retrieve >255 chars,
Daniel Selin, 01/03/2001
- <Possible follow-up(s)>
- Re: Retrieve >255 chars, Ilya Storozhilov, 01/03/2001
- Re: Retrieve >255 chars, Daniel Selin, 01/03/2001
- Re: Retrieve >255 chars, Stefan Bodewig, 01/03/2001
- Re: Retrieve >255 chars, Daniel Selin, 01/03/2001
Archive powered by MHonArc 2.6.24.