Can source code examples be kept in a SQL database while retaining all formatting? If so

Question

Can source code examples be kept in a SQL database while retaining all formatting (tabs, newlines, etc.)? If so what data type would be used?

Greg · Accepted Answer · 2008-10-30 14:39:48Z

1

Yes, use a TEXT type (or MEDIUMTEXT or LONGTEXT - you get the idea)

answered Oct 30, 2008 at 14:39

Greg

323k55 gold badges378 silver badges338 bronze badges

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

Comments

James Curran · Accepted Answer · 2008-10-30 14:40:04Z

1

A BLOB type (varbinary) would definitely work, although databases shouldn't mangle text that's stored as varchar either.

answered Oct 30, 2008 at 14:40

James Curran

104k37 gold badges186 silver badges264 bronze badges

Ovidiu Pacurar · Accepted Answer · 2008-10-30 14:40:40Z

1

The best in Sql Server: nvarchar(max)

answered Oct 30, 2008 at 14:40

Ovidiu Pacurar

8,2332 gold badges34 silver badges36 bronze badges

websch01ar · Accepted Answer · 2008-10-30 14:41:21Z

0

You can upload this into a blob data type. SQL 2008 comes with the capability of storing the entire executable file in the database.

answered Oct 30, 2008 at 14:41

websch01ar

2,1232 gold badges13 silver badges22 bronze badges