mysql> show create table tbl_char\G *************************** 1. row *************************** Table: tbl_char Create Table: CREATE TABLE `tbl_char` ( `col_0` varchar(255) character set big5 default NULL, `col_1` varchar(255) character set big5 collate big5_bin default NULL, `col_2` varchar(255) character set latin1 collate latin1_german1_ci default NULL, `col_3` varchar(255) default NULL, `col_4` varchar(255) character set latin1 collate latin1_danish_ci default NULL, `col_5` varchar(255) character set latin1 collate latin1_german2_ci default NULL, `col_6` varchar(255) character set latin1 collate latin1_bin default NULL, `col_7` varchar(255) character set latin1 collate latin1_general_ci default NULL, `col_8` varchar(255) character set latin1 collate latin1_general_cs default NULL, `col_9` varchar(255) character set latin1 collate latin1_spanish_ci default NULL, `col_10` varchar(255) character set latin2 collate latin2_czech_cs default NULL, `col_11` varchar(255) character set latin2 default NULL, `col_12` varchar(255) character set latin2 collate latin2_hungarian_ci default NULL, `col_13` varchar(255) character set latin2 collate latin2_croatian_ci default NULL, `col_14` varchar(255) character set latin2 collate latin2_bin default NULL, `col_15` varchar(255) character set ujis default NULL, `col_16` varchar(255) character set ujis collate ujis_bin default NULL, `col_17` varchar(255) character set sjis default NULL, `col_18` varchar(255) character set sjis collate sjis_bin default NULL, `col_19` varchar(255) character set tis620 default NULL, `col_20` varchar(255) character set tis620 collate tis620_bin default NULL, `col_21` varchar(255) character set euckr default NULL, `col_22` varchar(255) character set euckr collate euckr_bin default NULL, `col_23` varchar(255) character set gb2312 default NULL, `col_24` varchar(255) character set gb2312 collate gb2312_bin default NULL, `col_25` varchar(255) character set cp1250 default NULL, `col_26` varchar(255) character set cp1250 collate cp1250_czech_cs default NULL, `col_27` varchar(255) character set cp1250 collate cp1250_croatian_ci default NULL, `col_28` varchar(255) character set cp1250 collate cp1250_bin default NULL, `col_29` varchar(255) character set gbk default NULL, `col_30` varchar(255) character set gbk collate gbk_bin default NULL, `col_31` varchar(255) character set utf8 default NULL, `col_32` varchar(255) character set utf8 collate utf8_bin default NULL, `col_33` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, `col_34` varchar(255) character set utf8 collate utf8_icelandic_ci default NULL, `col_35` varchar(255) character set utf8 collate utf8_latvian_ci default NULL, `col_36` varchar(255) character set utf8 collate utf8_romanian_ci default NULL, `col_37` varchar(255) character set utf8 collate utf8_slovenian_ci default NULL, `col_38` varchar(255) character set utf8 collate utf8_polish_ci default NULL, `col_39` varchar(255) character set utf8 collate utf8_estonian_ci default NULL, `col_40` varchar(255) character set utf8 collate utf8_spanish_ci default NULL, `col_41` varchar(255) character set utf8 collate utf8_swedish_ci default NULL, `col_42` varchar(255) character set utf8 collate utf8_turkish_ci default NULL, `col_43` varchar(255) character set utf8 collate utf8_czech_ci default NULL, `col_44` varchar(255) character set utf8 collate utf8_danish_ci default NULL, `col_45` varchar(255) character set utf8 collate utf8_lithuanian_ci default NULL, `col_46` varchar(255) character set utf8 collate utf8_slovak_ci default NULL, `col_47` varchar(255) character set utf8 collate utf8_spanish2_ci default NULL, `col_48` varchar(255) character set utf8 collate utf8_roman_ci default NULL, `col_49` varchar(255) character set utf8 collate utf8_persian_ci default NULL, `col_50` varchar(255) character set utf8 collate utf8_esperanto_ci default NULL, `col_51` varchar(255) character set utf8 collate utf8_hungarian_ci default NULL, `col_52` varchar(255) character set ucs2 default NULL, `col_53` varchar(255) character set ucs2 collate ucs2_bin default NULL, `col_54` varchar(255) character set ucs2 collate ucs2_unicode_ci default NULL, `col_55` varchar(255) character set ucs2 collate ucs2_icelandic_ci default NULL, `col_56` varchar(255) character set ucs2 collate ucs2_latvian_ci default NULL, `col_57` varchar(255) character set ucs2 collate ucs2_romanian_ci default NULL, `col_58` varchar(255) character set ucs2 collate ucs2_slovenian_ci default NULL, `col_59` varchar(255) character set ucs2 collate ucs2_polish_ci default NULL, `col_60` varchar(255) character set ucs2 collate ucs2_estonian_ci default NULL, `col_61` varchar(255) character set ucs2 collate ucs2_spanish_ci default NULL, `col_62` varchar(255) character set ucs2 collate ucs2_swedish_ci default NULL, `col_63` varchar(255) character set ucs2 collate ucs2_turkish_ci default NULL, `col_64` varchar(255) character set ucs2 collate ucs2_czech_ci default NULL, `col_65` varchar(255) character set ucs2 collate ucs2_danish_ci default NULL, `col_66` varchar(255) character set ucs2 collate ucs2_lithuanian_ci default NULL, `col_67` varchar(255) character set ucs2 collate ucs2_slovak_ci default NULL, `col_68` varchar(255) character set ucs2 collate ucs2_spanish2_ci default NULL, `col_69` varchar(255) character set ucs2 collate ucs2_roman_ci default NULL, `col_70` varchar(255) character set ucs2 collate ucs2_persian_ci default NULL, `col_71` varchar(255) character set ucs2 collate ucs2_esperanto_ci default NULL, `col_72` varchar(255) character set ucs2 collate ucs2_hungarian_ci default NULL, `col_73` varchar(255) character set cp932 default NULL, `col_74` varchar(255) character set cp932 collate cp932_bin default NULL, `col_75` varchar(255) character set eucjpms default NULL, `col_76` varchar(255) character set eucjpms collate eucjpms_bin default NULL, KEY `col_0` (`col_0`), KEY `col_1` (`col_1`), KEY `col_2` (`col_2`), KEY `col_3` (`col_3`), KEY `col_4` (`col_4`), KEY `col_5` (`col_5`), KEY `col_6` (`col_6`), KEY `col_7` (`col_7`), KEY `col_8` (`col_8`), KEY `col_9` (`col_9`), KEY `col_10` (`col_10`), KEY `col_11` (`col_11`), KEY `col_12` (`col_12`), KEY `col_13` (`col_13`), KEY `col_14` (`col_14`), KEY `col_15` (`col_15`), KEY `col_16` (`col_16`), KEY `col_17` (`col_17`), KEY `col_18` (`col_18`), KEY `col_19` (`col_19`), KEY `col_20` (`col_20`), KEY `col_21` (`col_21`), KEY `col_22` (`col_22`), KEY `col_23` (`col_23`), KEY `col_24` (`col_24`), KEY `col_25` (`col_25`), KEY `col_26` (`col_26`), KEY `col_27` (`col_27`), KEY `col_28` (`col_28`), KEY `col_29` (`col_29`), KEY `col_30` (`col_30`), KEY `col_31` (`col_31`), KEY `col_32` (`col_32`), KEY `col_33` (`col_33`), KEY `col_34` (`col_34`), KEY `col_35` (`col_35`), KEY `col_36` (`col_36`), KEY `col_37` (`col_37`), KEY `col_38` (`col_38`), KEY `col_39` (`col_39`), KEY `col_40` (`col_40`), KEY `col_41` (`col_41`), KEY `col_42` (`col_42`), KEY `col_43` (`col_43`), KEY `col_44` (`col_44`), KEY `col_45` (`col_45`), KEY `col_46` (`col_46`), KEY `col_47` (`col_47`), KEY `col_48` (`col_48`), KEY `col_49` (`col_49`), KEY `col_50` (`col_50`), KEY `col_51` (`col_51`), KEY `col_52` (`col_52`), KEY `col_53` (`col_53`), KEY `col_54` (`col_54`), KEY `col_55` (`col_55`), KEY `col_56` (`col_56`), KEY `col_57` (`col_57`), KEY `col_58` (`col_58`), KEY `col_59` (`col_59`), KEY `col_60` (`col_60`), KEY `col_61` (`col_61`), KEY `col_62` (`col_62`), KEY `col_63` (`col_63`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.02 sec) mysql> show table status like 'tbl_char'; +----------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +----------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | tbl_char | MyISAM | 10 | Dynamic | 32608 | 5481 | 178739576 | 281474976710655 | 155757568 | 0 | NULL | 2007-06-21 10:25:15 | 2007-06-21 11:10:17 | 2007-06-21 11:10:17 | latin1_swedish_ci | NULL | | | +----------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec) mysql> E:\mysql-enterprise-gpl-5.0.40-win32\bin>myisamchk -dvvvi E:\builds\mysql-5.0.44-win-src\mysql-5.0.44\sql\data\g\tbl_char MyISAM file: E:\builds\mysql-5.0.44-win-src\mysql-5.0.44\sql\data\g\tbl_char Record format: Packed Character set: latin1_swedish_ci (8) File-version: 1 Creation time: 2007-06-21 8:25:15 Recover time: 2007-06-21 9:01:46 Status: crashed Data records: 32608 Deleted blocks: 0 Datafile parts: 32608 Deleted data: 0 Datafile pointer (bytes): 6 Keyfile pointer (bytes): 7 Datafile length: 178739576 Keyfile length: 155757568 Max datafile length: 281474976710654 Max keyfile length: -2 Recordlength: 41003 table description: Key Start Len Index Type Rec/key Root Blocksize 1 11 510 multip. ? prefix NULL 1 2516992 3072 2 523 510 multip. ? prefix NULL 1 5032960 3072 3 1035 255 multip. varchar prefix NULL 1 7475200 2048 4 1291 255 multip. varchar prefix NULL 1 9932800 2048 5 1547 255 multip. varchar prefix NULL 1 12390400 2048 6 1803 255 multip. varchar prefix NULL 1 14835712 2048 7 2059 255 multip. varchar prefix NULL 1 17293312 2048 8 2315 255 multip. varchar prefix NULL 1 19763200 2048 9 2571 255 multip. varchar prefix NULL 1 22239232 2048 10 2827 255 multip. varchar prefix NULL 1 24680448 2048 11 3083 255 multip. varchar prefix NULL 1 27131904 2048 12 3339 255 multip. varchar prefix NULL 1 29589504 2048 13 3595 255 multip. varchar prefix NULL 1 32051200 2048 14 3851 255 multip. varchar prefix NULL 1 34504704 2048 15 4107 255 multip. varchar prefix NULL 1 36952064 2048 16 4363 765 multip. ? prefix NULL 1 39600128 4096 17 5130 765 multip. ? prefix NULL 1 42250240 4096 18 5897 510 multip. ? prefix NULL 1 44733440 3072 19 6409 510 multip. ? prefix NULL 1 47206400 3072 20 6921 255 multip. varchar prefix NULL 1 49654784 2048 21 7177 255 multip. varchar prefix NULL 1 52106240 2048 22 7433 510 multip. ? prefix NULL 1 54651904 3072 23 7945 510 multip. ? prefix NULL 1 57201664 3072 24 8457 510 multip. ? prefix NULL 1 59705344 3072 25 8969 510 multip. ? prefix NULL 1 62175232 3072 26 9481 255 multip. varchar prefix NULL 1 64615424 2048 27 9737 255 multip. varchar prefix NULL 1 67068928 2048 28 9993 255 multip. varchar prefix NULL 1 69501952 2048 29 10249 255 multip. varchar prefix NULL 1 71965696 2048 30 10505 510 multip. ? prefix NULL 1 74557440 3072 31 11017 510 multip. ? prefix NULL 1 77159424 3072 32 11529 765 multip. ? prefix NULL 1 78153728 4096 33 12296 765 multip. ? prefix NULL 1 79157248 4096 34 13063 765 multip. ? prefix NULL 1 80168960 4096 35 13830 765 multip. ? prefix NULL 1 81180672 4096 36 14597 765 multip. ? prefix NULL 1 82196480 4096 37 15364 765 multip. ? prefix NULL 1 83208192 4096 38 16131 765 multip. ? prefix NULL 1 84215808 4096 39 16898 765 multip. ? prefix NULL 1 85219328 4096 40 17665 765 multip. ? prefix NULL 1 86218752 4096 41 18432 765 multip. ? prefix NULL 1 87226368 4096 42 19199 765 multip. ? prefix NULL 1 88242176 4096 43 19966 765 multip. ? prefix NULL 1 89257984 4096 44 20733 765 multip. ? prefix NULL 1 90261504 4096 45 21500 765 multip. ? prefix NULL 1 91269120 4096 46 22267 765 multip. ? prefix NULL 1 92284928 4096 47 23034 765 multip. ? prefix NULL 1 93288448 4096 48 23801 765 multip. ? prefix NULL 1 94291968 4096 49 24568 765 multip. ? prefix NULL 1 95307776 4096 50 25335 765 multip. ? prefix NULL 1 96315392 4096 51 26102 765 multip. ? prefix NULL 1 97327104 4096 52 26869 765 multip. ? prefix NULL 1 98334720 4096 53 27636 510 multip. ? prefix NULL 1 103109632 3072 54 28148 510 multip. ? prefix NULL 1 107929600 3072 55 28660 510 multip. ? prefix NULL 1 112691200 3072 56 29172 510 multip. ? prefix NULL 1 117455872 3072 57 29684 510 multip. ? prefix NULL 1 122242048 3072 58 30196 510 multip. ? prefix NULL 1 127012864 3072 59 30708 510 multip. ? prefix NULL 1 131780608 3072 60 31220 510 multip. ? prefix NULL 1 136545280 3072 61 31732 510 multip. ? prefix NULL 1 141371392 3072 62 32244 510 multip. ? prefix NULL 1 146166784 3072 63 32756 510 multip. ? prefix NULL 1 150980608 3072 64 33268 510 multip. ? prefix NULL 1 155754496 3072 Field Start Length Nullpos Nullbit Type 1 1 10 2 11 512 1 1 varchar 3 523 512 1 2 varchar 4 1035 256 1 4 varchar 5 1291 256 1 8 varchar 6 1547 256 1 16 varchar 7 1803 256 1 32 varchar 8 2059 256 1 64 varchar 9 2315 256 1 128 varchar 10 2571 256 2 1 varchar 11 2827 256 2 2 varchar 12 3083 256 2 4 varchar 13 3339 256 2 8 varchar 14 3595 256 2 16 varchar 15 3851 256 2 32 varchar 16 4107 256 2 64 varchar 17 4363 767 2 128 varchar 18 5130 767 3 1 varchar 19 5897 512 3 2 varchar 20 6409 512 3 4 varchar 21 6921 256 3 8 varchar 22 7177 256 3 16 varchar 23 7433 512 3 32 varchar 24 7945 512 3 64 varchar 25 8457 512 3 128 varchar 26 8969 512 4 1 varchar 27 9481 256 4 2 varchar 28 9737 256 4 4 varchar 29 9993 256 4 8 varchar 30 10249 256 4 16 varchar 31 10505 512 4 32 varchar 32 11017 512 4 64 varchar 33 11529 767 4 128 varchar 34 12296 767 5 1 varchar 35 13063 767 5 2 varchar 36 13830 767 5 4 varchar 37 14597 767 5 8 varchar 38 15364 767 5 16 varchar 39 16131 767 5 32 varchar 40 16898 767 5 64 varchar 41 17665 767 5 128 varchar 42 18432 767 6 1 varchar 43 19199 767 6 2 varchar 44 19966 767 6 4 varchar 45 20733 767 6 8 varchar 46 21500 767 6 16 varchar 47 22267 767 6 32 varchar 48 23034 767 6 64 varchar 49 23801 767 6 128 varchar 50 24568 767 7 1 varchar 51 25335 767 7 2 varchar 52 26102 767 7 4 varchar 53 26869 767 7 8 varchar 54 27636 512 7 16 varchar 55 28148 512 7 32 varchar 56 28660 512 7 64 varchar 57 29172 512 7 128 varchar 58 29684 512 8 1 varchar 59 30196 512 8 2 varchar 60 30708 512 8 4 varchar 61 31220 512 8 8 varchar 62 31732 512 8 16 varchar 63 32244 512 8 32 varchar 64 32756 512 8 64 varchar 65 33268 512 8 128 varchar 66 33780 512 9 1 varchar 67 34292 512 9 2 varchar 68 34804 512 9 4 varchar 69 35316 512 9 8 varchar 70 35828 512 9 16 varchar 71 36340 512 9 32 varchar 72 36852 512 9 64 varchar 73 37364 512 9 128 varchar 74 37876 512 10 1 varchar 75 38388 512 10 2 varchar 76 38900 512 10 4 varchar 77 39412 767 10 8 varchar 78 40179 767 10 16 varchar E:\mysql-enterprise-gpl-5.0.40-win32\bin>