Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
godspeedba
Yak Posting Veteran
90 Posts |
 Posted - 2009-03-30 : 11:56:59
|
| What's the best way to store html code into an SQL database.HTML code length about 1500 alphanumeric bits of data.I was hoping to get this into the database without the use of html.encoding. Is this possible?Will it be ok to chuck it into a large Char field? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-30 : 13:53:45
|
| Varchar is better, you can specify from 1 to 8000 characters, or use varchar(max) to store up to 2 GB. If you need to support Unicode, use nvarchar instead. See Books Online for more details. |
 |
|
|
godspeedba
Yak Posting Veteran
90 Posts |
Posted - 2009-03-31 : 06:32:37
|
| Nice one chief |
|
|
|
|
|
|
HTML code in SQL