SQL Server and text data type

[Immy]

I have a table in SQL Server 7.0 and one of the elements has been defined
as a text data type. When I insert data into the element using and SQL statement
or the appendchunk method, for some reason, if there is a null within my
data, it truncates the data up from the null onwards, so the data on my
table does not fully reflect the data that was sent to it. ANyone had this
sort of problem or know how I could resolve this problem.

Your help is greatly appreciated

Imran

[Michael Levy]

If you really need to keep the char(0), why not change the field to
(var)binary or image instead of text?

-Mike
--
Michael Levy MCDBA, MCSD, MCT
michaell@gasullivan.com

[immy]

I tried that and it gave the same error.

"Michael Levy" <michaell@gasullivan.com> wrote:
>If you really need to keep the char(0), why not change the field to
>(var)binary or image instead of text?
>
>-Mike
>--
>Michael Levy MCDBA, MCSD, MCT
>michaell@gasullivan.com
>
>

[Michael Levy]

I was able to place a NULL (char(0)) into a varbinary column with the
following from within the Query Analyzer:

create table t (b varbinary(10))
insert into t values (0x00)
select * from t

I wonder if the problem is in front-end that you're using to load the data?

-Mike
--
Michael Levy MCDBA, MCSD, MCT
michaell@gasullivan.com