Page 1 of 1

varchar character limit

Posted: Mon May 05, 2003 3:32 pm
by jkj2001
It's my understanding that if you create, say, a varchar(255) field in a table, you can still add 256+ characters to it; the field will expand depending on need.

However, when does this "dynamic expansion start to break down? A thousand characters? A million?

We're debating whether to make a field of ours a blob or varchar, and this is one of the factors we'll take into account. Thanks for the advice.

varchar character limit

Posted: Mon May 05, 2003 3:51 pm
by mark
It doesn't break down. A varchar may be as big as a blob, 1 gigabyte max. A varchar field does not use any more space than needed. About the only time the length spec of a varchar field even matters is if that field is used as an aux field in a combined metamorph index.

varchar character limit

Posted: Mon May 05, 2003 4:50 pm
by John
When choosing between varchar and blob it is much more important to consider how the data will be accessed. If for the most part the data will not be read, e.g. searched with an index, but not selected, then a blob can be helpful.