Hi,

I have a basic insert statement like this,
INSERT INTO TRANS ( pin , date , time , type , amount , descr , userid ) VALUES ( '111111' , '20070425' , '230904' , '1Œ' , 3100 , '' , 'TEST' )

The table structure of TRANS is
CREATE TABLE [dbo].[trans] (
[pin] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[date] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[time] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[type] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[amount] [int] NULL ,
[descr] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[userid] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

The insert is successful on one machine and gives error on one machine.
The error is as follows.
Insert String #8152: String or binary data would be truncated.

I understand that it is complaining that it cannot put '1Œ' value into a char 1 field. But my question is how is it working on the other machine. I traced the table with the profiler and I get the same kind of insert statement on both the machines.

Please help.
Thanks.