Best data type to store html css javascript

Question

Good day.

I have a PHP & MySql background, and I'm just starting with ASP.NET. I don't have any background with ASP, only have experience with C#.

Well my problem its very simple, i would like to be able to save HTML, CSS and Javascript code directly to a MS SQL Server database.

However i don't know which data type is more advised to store code, bare in mind that i would like to keep the original code formatting (break lines, formating, etc).

Any help is appreciated.

Environment Details:

Windows 7 (x86)
Visual Studio 2010 Ultimate
Sql Server 2008
ASP.NET & C#
NET Framework 4.0

Thanks.

Brian Ball · Accepted Answer · 2010-12-23 20:22:15Z

5

varchar(#) if you know you will not be storing unicode characters, if you are going to store unicode characters use nvarchar(#). Replace the # with the max number of characters. You can also specify max instead of a number and it will store as much as you want (there probably is a limit, but I haven't run into it yet).

answered Dec 23, 2010 at 20:22

Brian Ball

12.7k3 gold badges43 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrew Barber Over a year ago

It should be noted that nvarchar(MAX) and varchar(MAX) really are almost totally different data types from nvarchar(x) and varchar(x); the MAX versions are optimized for storing large amounts of text, and making it available for Full Text Search. The data size limit is 2GB-1, so that's not usually an issue.

gbn · Accepted Answer · 2010-12-23 20:23:03Z

1

Use the large text datatypes varchar(max) or nvarchar(max) which allow up to 2GB-1 bytes of data

From MSDN on text and ntext

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

answered Dec 23, 2010 at 20:23

gbn

435k84 gold badges602 silver badges690 bronze badges

Comments

Scott · Accepted Answer · 2010-12-23 20:22:55Z

0

For future compatibility, use the VARCHAR(MAX) data type. In SQL Server 2005 Microsoft added support for varchar(max) and nvarchar(max), this new datatype can be used anywhere a regular length limited varchar can, but lets you store up to 2GB of data. Behind the scenes the varchar(max) stores up to as much of the text as it can in the row (up to 8K), and then creates additional pages for any additional text. So in a lot of cases the text content will fit in the row, requiring much less disk IO.

Microsoft is said to be deprecating the text and ntext data types in future releases.

answered Dec 23, 2010 at 20:22

Scott

14k20 gold badges99 silver badges157 bronze badges

Comments

user3666197 · Accepted Answer · 2016-11-23 11:28:27Z

0

You can use nText or Text
if you have unicode language in your html use nText
nText has unlimited lenght column for your data

edited Nov 23, 2016 at 11:28

user3666197

1

answered Nov 23, 2016 at 11:06

Dev With MJ

921 silver badge8 bronze badges

Collectives™ on Stack Overflow

Best data type to store html css javascript

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related