Friday, February 10, 2012

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 tha
n
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...
>
>|||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...[vbcol=seagreen]
> 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:
>

No comments:

Post a Comment