What is the canonical way to store arbitrary (possibly tagged) text in SQL?

Question

What is wiki / stackoverflow / etc. do when it comes to storing text? Is text broken for newlines? Does it break into pieces of fixed length? What is the best way to store arbitrarily long pieces of text?

Answer 1

nvarchar (max) ftw. because simple things that are too complicated are bad, mmkay?

Answer 2

I assume that if you need to provide the ability to store large fragments of text, and you do not mind that you cannot look too much into their contents when prompted, you can use CLob.

Answer 3

, , . , - , , /, . , , .

, RDBMS, , ( varchar (max)). , .

Answer 4

PostgreSQL - BYTEA. , .

Answer 5

, , "" , , , , - db .

.

Answer 6

, StackOverflow "" . , UTF8 ( UTF16 - . , SQL Server, ).

, " " . , , , , (, Markdown, HTML, "" )

Answer 7

, , , , ..

, SQL Server, , . SQL Server 2005 nvarchar (max) . , / , , StackOverflow.com.

. , .

, , , . HTML, , .

, , , Unicode UTF-8 . . . , , ASCII , ..

Answer 8

SQL Server:

varchar (max) . , 2 .

. , . .Net SqlCommand LinqToSQL ( SqlCommand ).