to BLOB or not to BLOB

Started by Aristide Aragonalmost 25 years ago1 messagesgeneral
Jump to latest
#1Aristide Aragon
zuri@busa.lionking.org

Hello

I am going to write an application tht writes big amounts of plain text into a database.
I thought of using the text type for this, but I don't know if it has a maxlenght, and given that these will be very long texts I started wondered if these would have to be blobs... but they aren't binary.
So, does the text daya type have a maxium lenght? Do BLOBs? What should I use? For the time being, at least, I won't be searching these texts with a search engine or anything... but if I were to be, what considerations should I take into account when designing the tables?

Thanks in advance

Aristide Aragon