to BLOB or not to BLOB

Поиск
Список
Период
Сортировка
От Aristide Aragon
Тема to BLOB or not to BLOB
Дата
Msg-id 20010514001726.D1323@busa.lionking.org
обсуждение исходный текст
Список pgsql-general
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
longtexts 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
searchingthese texts with a search engine or anything... but if I were to be, what considerations should I take into
accountwhen designing the tables? 

Thanks in advance

Aristide Aragon

В списке pgsql-general по дате отправления:

Предыдущее
От: u95886230@spawnkill.ip-mobilphone.net
Дата:
Сообщение: sql question
Следующее
От: Giorgio Valoti
Дата:
Сообщение: Docs about full text search