Re: Select instruction not returning entire column (explicit truncate ???)
From: Steve Kass (skass_at_drew.edu)
Date: 03/22/04
- Next message: Yanick Charland: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Previous message: Yanick Charland: "Select instruction not returning entire column (explicit truncate ???)"
- In reply to: Yanick Charland: "Select instruction not returning entire column (explicit truncate ???)"
- Next in thread: Yanick Charland: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Reply: Yanick Charland: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Mar 2004 10:53:23 -0500
Yanick,
What tool are you using? Perhaps you are using Query Analyzer with
grid output, and the strings contain non-printing characters like
char(0) or others below char(32)? See if you see everything after
converting the strings to varbinary(2000), and try text output after
setting Tools|Options|Results|Maximum Characters Per Column to a large
value. If there are non-printing characters in the strings, there is no
guarantee with any tool that you will see the contents correctly.
Steve Kass
Drew University
Yanick Charland wrote:
>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: Yanick Charland: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Previous message: Yanick Charland: "Select instruction not returning entire column (explicit truncate ???)"
- In reply to: Yanick Charland: "Select instruction not returning entire column (explicit truncate ???)"
- Next in thread: Yanick Charland: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Reply: Yanick Charland: "Re: Select instruction not returning entire column (explicit truncate ???)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
