Difference between TINYTEXT and VARCHAR?

mp96brbj

What's the difference between TINYTEXT and VARCHAR? They are both strings of variable length up to 255.

Is it that TINYTEXT is searched in a case-insensitive manner? In that case I'd like to reformulate the question: What's the difference between TINYBLOB and VARCHAR? 'Cause BLOBs are case-sensitive, aren't they?

Anon

Here's a link we you can start to find out:

http://www.mysql.com/doc/C/H/CHAR.html

Anon

Actually, TinyText is not mean to be a variable length. It is meant to be a fixed length string upto 255, while varchar is meant to be a variable length upto 255.

Hope that helps,
Richard

Anon

Doh!!! I take that back, Char is a fixed length upto 255... Well, both of them are variable length (as you said). Both of them are case insensitive unless you use the binary option. The differences as listed in the docs are as follows:

-You can have indexes on TEXT columns with MySQL Version 3.23.2 and newer. Older versions of MySQL did not support this.
-There is no trailing space removal for TEXT columns when values are stored as there is for VarChar.
-Text columns cannot have DEFAULT values.

So there you go. No default and No trailing space removal. So if you save a string such as:

"This is some text "

Varchar will store it as
"This is some text"
while TinyText will store it as
"This is some text ".

Hope that helps,
Richard