November 2, 2005 at 9:18 am
MS SQL Server 2000
I have a field of type text:
CREATE TABLE dbo.glb_email
(
email_id int NOT NULL IDENTITY (1, 1),
type varchar (200) NOT NULL ,
title varchar (200) NOT NULL ,
subject varchar (800) NOT NULL ,
body text NOT NULL
)
I run this insert:
insert into glb_email (type, title, subject, body)values('PAS-1', 'Add New Password, 'Subject Text', REPLACE('
We understand that you have recently or may soon receive.
For your convenience, allows you to provide this information and complete the necessary forms via the Internet from any web-accessed computer using the Online Compliance System. You must access and provide the requested information within days of receiving this message.
If you have any questions or need additional information about
Thank you for your prompt attention to this matter.
', '''', '')
)
If I run 'select body from glb_email'
I only get 255 or less characters back! What gives?
November 2, 2005 at 10:07 am
insert into glb_email (type, title, subject, body)values('PAS-1', 'Add New Password, 'Subject Text', REPLACE('
We understand that you have recently or may soon receive.
For your convenience, allows you to provide this information and complete the necessary forms via the Internet from any web-accessed computer using the Online Compliance System. You must access and provide the requested information within days of receiving this message.
If you have any questions or need additional information about
Thank you for your prompt attention to this matter.
', '''', '')
Is this a typo?
'Add New Password' <-- missing single quote!
November 2, 2005 at 10:10 am
just a typo, do you know why my text is being truncated?
November 2, 2005 at 10:12 am
If you are using QA, check out the value of Tools/Options/Results/Maximum characters per column.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
November 2, 2005 at 10:15 am
That was it thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply