Select instruction not returning entire column (explicit truncate ???)
From: Yanick Charland (yanickcharland_at_hotmail.com)
Date: 03/22/04
- Next message: Steve Kass: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Previous message: Jose Patric: "Converting data type Binary into Character-URGENT"
- Next in thread: Steve Kass: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Reply: Steve Kass: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Mar 2004 06:16:44 -0800
Good day,
[SQL Server 7.0, SP4]
I have a table wich contains only one column [varchar
(1500)] filled with some texts (different length, ranging
from 150 chars up to 1200s). When I execute "Select * from
Table1", I only get parts of my texts; the returned
strings are truncated, but not all at the same size...
What am I missing here ? When I open my table in
Entreprise manager, I see my texts the way they should
be... complete !
Thanks for your help... I badly need it !
Yanick Charland
- Next message: Steve Kass: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Previous message: Jose Patric: "Converting data type Binary into Character-URGENT"
- Next in thread: Steve Kass: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Reply: Steve Kass: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Messages sorted by: [ date ] [ thread ]