Myisam

Discussion in 'Databases' started by zodiac, Mar 18, 2007.

0
  1. #1
    to have the engine MYISAM instead of HEAP,do i just rename it?
    is the CHARSET ok?
    CREATE TABLE `table` (
  `line_id` int(11) NOT NULL default '0',
  `from_id` int(11) NOT NULL default '0',
  `from_name` varchar(64) NOT NULL default '',
  `line_stamp` int(11) NOT NULL default '0',
  `line_txt` varchar(255) NOT NULL default '',
  `line_biu` char(3) NOT NULL default '',
  `line_clr` varchar(32) NOT NULL default ''
) ENGINE=MYISAM DEFAULT CHARSET=latin1 MAX_ROWS=15000;
    Code (markup):

     
    zodiac, Mar 18, 2007 IP
  2. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you have already created the database then on First Page of phpMyAdmin there is option to convert database type. Charset is dependent on characters 'you will insert'. Use UTF if your not certain.
     
    sadcox66, Mar 21, 2007 IP