Save html content to SqlServer
-
Hello I want to save large data in database. This data is string and may be contains up to 2 pages. -> Which field i should choose for it in SqlServer 2005? -> I want to save line breaks (Enter Key) and retrive the text from database like i saved it before to database, Somebody says i should save it in html format! How can i do it? Tanx
-
Hello I want to save large data in database. This data is string and may be contains up to 2 pages. -> Which field i should choose for it in SqlServer 2005? -> I want to save line breaks (Enter Key) and retrive the text from database like i saved it before to database, Somebody says i should save it in html format! How can i do it? Tanx
In SqlServer 2005 You can use varchar(max), or nvarchar(max) for this purpose. It is same as varchar or nvarchar, only difference is that it can store large value.
Viral YahooID : just_viral My Site : www.theseoworld.info
-
Hello I want to save large data in database. This data is string and may be contains up to 2 pages. -> Which field i should choose for it in SqlServer 2005? -> I want to save line breaks (Enter Key) and retrive the text from database like i saved it before to database, Somebody says i should save it in html format! How can i do it? Tanx
hello freshonlineMax, do you want to save HTML page ??? if yes then use BLOB method to save the data and use the image field in SQLserver the size of this field is 16 bit i think it will helpful for U, if you want to save HTML page regards, -koolprasad2003
N-Joy
-
Hello I want to save large data in database. This data is string and may be contains up to 2 pages. -> Which field i should choose for it in SqlServer 2005? -> I want to save line breaks (Enter Key) and retrive the text from database like i saved it before to database, Somebody says i should save it in html format! How can i do it? Tanx
Save that in 'Text' format. You can save upto many pages. You can retrieve back the original thing..