How to decide the type of table - newbie

Hi!

Hi!

Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL ver.
4.0.15a, PHP 4.2.3, all of them on same machine.

I'm going to build my first DB.
Using the phpMyAdmin I'm asked to choose for every table in the DB the type:
default, MyISAM, Heap, Merge, INNO DB, ISAM.
What are the PRO and CONS for every type?
I'm going to enter data typed with  Hebrew characters (the funny letters written
from right to left;-) )/

TIA

Nanu

Hi!


>
> I'm going to build my first DB.
> Using the phpMyAdmin I'm asked to choose for every table in the DB the
type: default, MyISAM, Heap, Merge, INNO DB, ISAM.
> What are the PRO and CONS for every type?


See here for an overview......
http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html

There is only two practical choices. MyISAM or InnoDB. I'd personally go
with InnoDB, since it has better handling of mixture of
SELECT/INSERT/UPDATE/DELETE and has better crash recovery.


> I'm going to enter data typed with  Hebrew characters (the funny letters
written from right to left;-) )/
>

You'd need UTF8 all around.


Regards,
deva