TEXT vs VARCHAR
| От | chris markiewicz |
|---|---|
| Тема | TEXT vs VARCHAR |
| Дата | |
| Msg-id | 008e01c032ea$52c6a4e0$dbb846c6@cmarkiewicz обсуждение исходный текст |
| Ответ на | Re: Some advanced database features, are they present in PostgreSQL (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: TEXT vs VARCHAR
|
| Список | pgsql-general |
hello. i am faced with a situation where i must store a potentially large ascii string (several thousand characters?). i am looking for some insight beyond what the documentation offers... is there a limit on the upper limit of a VARCHAR? i cannot find one in the documentation. is it true that a TEXT field can be any size? what is the best way to manage memory? for example, if i declare it as VARCHAR(10000), does that mean that memory for 10,000 characters will be allocated whether i use it or not, or is it dynamic? how about the TEXT type. thanks chris
В списке pgsql-general по дате отправления: