Charles Adriano [Brasil] Guest
|
Posted: Wed Aug 18, 2004 7:10 pm Post subject: Text field problem.... |
|
|
hi all
i have this table
CREATE TABLE [Table1]
(
[A] [nvarchar] (36) COLLATE Latin1_General_CI_AS NULL ,
[B] [text] COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
and when i insert data
INSERT INTO Table1 (A, B) VALUES ('S', REPLICATE('B', 900))
work ok, but
INSERT INTO Table1 (A, B) VALUES ('S', REPLICATE('B', 901))
not insert field B (901 or more bytes) it's empty....
why?
--
Charles Adriano
-------------------------
Conhecimento é Poder...
------=|ÐööMGµä®Ð|=------
|
|