mysql text type

hi

which one is the best for use for performance and storage -
MEDIUMBLOB or MEDIUMTEXT?


thanxs
yakuza [ Mi, 21 Februar 2007 15:22 ] [ ID #1638304 ]

Re: mysql text type

akuza wrote:
> hi
>
> which one is the best for use for performance and storage -
> MEDIUMBLOB or MEDIUMTEXT?

Depends on what you want to store, just standard text, then go with TEXT, but
if you want to store images, binaries then go with BLOB.

--

//Aho
Shion [ Mi, 21 Februar 2007 15:51 ] [ ID #1638305 ]

Re: mysql text type

Post removed (X-No-Archive: yes)
Notifier Deamon [ Mi, 21 Februar 2007 19:29 ] [ ID #1638306 ]

Re: mysql text type

The text i will be storing will be over 500 characters with no images
so i think text sounds good to me.

thanx guys for your answers.
yakuza [ Do, 22 Februar 2007 12:28 ] [ ID #1638309 ]

Re: mysql text type

عرب زواج wrote:
> بسم الله الرحمن الرحيم

God don't understand SQL, he still tries to manage to write arabic and the
girls you are selling, I hope they will outlive the men they are forced to marry.


--

//Aho
Shion [ Sa, 24 Februar 2007 03:12 ] [ ID #1638313 ]
PHP » alt.php.sql » mysql text type

Vorheriges Thema: PHP & MSSQL Express issues (Newbie)
Nächstes Thema: A better select?