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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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