using string, blob or clob for thread body in doctrine?

what data type (string, blob or clob) should i use for my thread body when using doctrine?

and what length should it be?

i have read the documentation but dont quite understand the differences between them.

seems that all three can store unlimited nr of characters.

could someone explain

and how do i store unlimited characters in string? what should i set as length?

+1 A:

1) What is a "thread"?

2) Use text without a length for up to 65536 characters, which is probably enough for most uses.

Coronatus 2010-04-18 15:08:24

there is no datatype named text for doctrine:)

never_had_a_name 2010-04-18 15:51:10

text = array in Doctrine.

Tom 2010-04-18 17:31:54

text = string(1000) in Doctrine. Array uses text datatype, but it has some additional behaviour.

Crozin 2010-04-18 20:54:23

+1 A:

I would prefer blob as datatype, to store unlimited text with all the richtext formating stuff.

ArneRie 2010-04-18 15:51:35

Blobs aren't very queryable - make sure you don't want to do text searches before you commit to a non-text datatype.

2010-04-19 10:46:40

ansaurus