Обсуждение: VARCHAR AND TEXT DATA TYPES

Поиск
Список
Период
Сортировка

VARCHAR AND TEXT DATA TYPES

От
"JORGE MALDONADO"
Дата:
If I need a field of type character without size limit, should I use VARCHAR specifying no length or TEXT?
What would be the difference?
 
With respect,
Jorge Maldonado

Re: VARCHAR AND TEXT DATA TYPES

От
ries van Twisk
Дата:
On Jan 5, 2009, at 5:44 PM, JORGE MALDONADO wrote:

> If I need a field of type character without size limit, should I use
> VARCHAR specifying no length or TEXT?
> What would be the difference?

Use Text, internally there is no difference between varchar and text
except that varchar has a added contraint with lenght.

>
> With respect,
> Jorge Maldonado


Ries