Posted by MaKroZ on 01/26/06 21:25

On Thu, 26 Jan 2006 11:51:19 +0000, jack wrote:

> ...So I'm left with TEXT or
> BLOB which after experimenting works but I'm not sure of any disadvantages
> with either.
> Can I get some feedback as what is recommended for something like this? I've
> read the MySQL site regarding these two fields but it went way over my head!
>
> thanks

BLOB is for binary data, TEXT is for text. Both of them stores data in the
same way. However in searching and sorting MySQL manipulates with TEXT as
it's text data and with BLOB as it's binary. That means 'A'!='a' in
BLOB, but 'A'=='a" in TEXT. Store text in TEXTs and pictures in BLOB.

Character sets are for making TEXT (and chars and varchars) work properly
with international alphabets. It effects text searching and comparing,
sorting in alphabetical order, concatinating and splitting etc.

--
nn My bookmarks:
(oo) http://www.yakutia.org
| | http://www.theisplist.com
|/\| http://www.tenpieces.com

[Back to original message]