Comparison between 6.5 and 2000 inserts

Hi,
I am kind of baffeled. I have a table with a column of 8 varchar in 2000
and the same in 6.5. When I insert into 2000 with a data length of more than
8 chars via Cold Fusion into the table, it fails. The same Cold Fusion
program inserts into the 6.5 table, but truncates the data but does not fail.
Does anyone know why this happens. Thanks.
--
New SQL Server DBACheck the value of the ANSI_WARNINGS setting for the session.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:05F1A1E0-A59B-4937-912B-F968C7668FFD@.microsoft.com...
> Hi,
> I am kind of baffeled. I have a table with a column of 8 varchar in 2000
> and the same in 6.5. When I insert into 2000 with a data length of more
> than
> 8 chars via Cold Fusion into the table, it fails. The same Cold Fusion
> program inserts into the 6.5 table, but truncates the data but does not
> fail.
> Does anyone know why this happens. Thanks.
> --
> New SQL Server DBA|||Thank you for the suggestion, I will research. But why does it fail the
insert in 6.5 if I run the insert statement, where the data is longer that 8
char, via sql server query analyzer and not via Cold Fusion? Shouldn't it
also work in sql query analyzer? Thanks.
--
New SQL Server DBA
"Jerry Spivey" wrote:
> Check the value of the ANSI_WARNINGS setting for the session.
> HTH
> Jerry
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:05F1A1E0-A59B-4937-912B-F968C7668FFD@.microsoft.com...
> > Hi,
> >
> > I am kind of baffeled. I have a table with a column of 8 varchar in 2000
> > and the same in 6.5. When I insert into 2000 with a data length of more
> > than
> > 8 chars via Cold Fusion into the table, it fails. The same Cold Fusion
> > program inserts into the 6.5 table, but truncates the data but does not
> > fail.
> > Does anyone know why this happens. Thanks.
> > --
> > New SQL Server DBA
>
>|||ANSI_WARSNINGS is a connection setting. QA probably turn this on by default where ColdFusion doesn't
(leaves it to default).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:75EDE8A5-D913-4084-A7C9-28D80AC41202@.microsoft.com...
> Thank you for the suggestion, I will research. But why does it fail the
> insert in 6.5 if I run the insert statement, where the data is longer that 8
> char, via sql server query analyzer and not via Cold Fusion? Shouldn't it
> also work in sql query analyzer? Thanks.
> --
> New SQL Server DBA
>
> "Jerry Spivey" wrote:
>> Check the value of the ANSI_WARNINGS setting for the session.
>> HTH
>> Jerry
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:05F1A1E0-A59B-4937-912B-F968C7668FFD@.microsoft.com...
>> > Hi,
>> >
>> > I am kind of baffeled. I have a table with a column of 8 varchar in 2000
>> > and the same in 6.5. When I insert into 2000 with a data length of more
>> > than
>> > 8 chars via Cold Fusion into the table, it fails. The same Cold Fusion
>> > program inserts into the 6.5 table, but truncates the data but does not
>> > fail.
>> > Does anyone know why this happens. Thanks.
>> > --
>> > New SQL Server DBA
>>