phpbar.de logo

Mailinglisten-Archive

[php] Was sollte ich machen bevor ich ein Textfeld in eine Datenbank speichere?

[php] Was sollte ich machen bevor ich ein Textfeld in eine Datenbank speichere?

Tobias Orterer php_(at)_phpcenter.de
Fri, 20 Apr 2001 14:35:11 +0200


A BLOB is a binary large object that can hold a variable amount of data.
The four BLOB types TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB differ only
in the maximum length of the values they can hold. See section 7.3.1
Column Type Storage Requirements. 

The four TEXT types TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT correspond
to the four BLOB types and have the same maximum lengths and storage
requirements. The only difference between BLOB and TEXT types is that
sorting and comparison is performed in case-sensitive fashion for BLOB
values and case-insensitive fashion for TEXT values. In other words, a
TEXT is a case-insensitive BLOB. 

ok gut... wobei dann aber trotzdem TEXT besser is für text...


php::bar PHP Wiki   -   Listenarchive