VARCHAR versus TEXT or LONGTEXT

sql varchar longtext
user1794491 picture user1794491 · Nov 2, 2012 · Viewed 17.2k times · Source

If a blog post is 200 characters long, will varchar(6500) only consume the space of varchar(200)?

Will this be more efficient than using TEXT or LONGTEXT?

Answer

Waqar Alamgir picture Waqar Alamgir · Nov 2, 2012

TEXT is stored off the table it has reference of it only.

While

VARCHAR is stored inline with the table and usually used with less size. You can use it to max 65535 but very bad actually in terms of performance.

So that you can optimized table and queries, performance may very with DBMS. If you have variable but larger string I would suggest using TEXT

Related questions

SQL Server Convert Varchar to Datetime

I have this date format: 2011-09-28 18:01:00 (in varchar), and I want to convert it to datetime changing to this format 28-09-2011 18:01:00. How can I do it?

Read More
Changing the maximum length of a varchar column?

I'm trying to update the length of a varchar column from 255 characters to 500 without losing the contents. I've dropped and re-created tables before but I've never been exposed to the alter statement which is what I believe I need to …

Read More
Difference between BYTE and CHAR in column datatypes

In Oracle, what is the difference between : CREATE TABLE CLIENT ( NAME VARCHAR2(11 BYTE), ID_CLIENT NUMBER ) and CREATE TABLE CLIENT ( NAME VARCHAR2(11 CHAR), -- or even VARCHAR2(11) ID_CLIENT NUMBER )

Read More