1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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