* florian
> but except for that text can store more than 255 chars is there
> any difference between varchar and text/blob?
>From the manual:
"In most respects, you can regard a `TEXT' column as a `VARCHAR' column
that can be as big as you like. Similarly, you can regard a `BLOB'
column as a `VARCHAR BINARY' column. The differences are:
* You can have indexes on `BLOB' and `TEXT' columns with *MySQL*
versions 3.23.2 and newer. Older versions of *MySQL* did not
support this.
* There is no trailing-space removal for `BLOB' and `TEXT' columns
when values are stored, as there is for `VARCHAR' columns.
* `BLOB' and `TEXT' columns cannot have `DEFAULT' values."
--
Roger
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
