[TriLUG] Interesting article: Ellison: Linux will wipe Microsoft out of the data center
Joseph Tate
jtate at dragonstrider.com
Thu Apr 3 14:22:19 EST 2003
BLOB == BINARY large object. TEXT !=BLOB. If you want to store MP3
files in MySQL how would you do it? BASE 64 Encode it?
Jeremy Portzer wrote:
>On Thu, 2003-04-03 at 13:53, Joseph Tate wrote:
>
>
>>Stored procedures (PL/pgSQL or C). Triggers. I can't remember if Mysql
>>supports BLOBs or not, but Postgres does. Up until 4.x there wasn't any
>>transaction support (Commit/Rollback) in Mysql.
>>
>>
>>
>
>MySQL does support BLOB equivalents (called TEXT I believe), and what
>I've heard is that they perform much better than Postgres. But yes, the
>lack of stored procedures and triggers does make MySQL much less
>useful. I haven't played with MySQL 4 yet, but the 3.23 versions don't
>even support row-level locking or transactions (unless you use a
>non-free(dom) software table type).
>
>--Jeremy
>
>
>
More information about the TriLUG
mailing list