The default charset of c is utf8, and that of a and b is latin1. Maybe charset cause size of table increased? -- Thanks & Regards Chylli
Of course this is it ! Latin1 needss one byte per character ... while utf needs from 1 to 3 bytes per character. Still the rate of growing 1,9 can only be explained (as far as i know) if you have CHAR columns. On utf8 if you have a column defined as CHAR (20) CHARSET utf8... to keep the table fixed-size (whether you store in it all 1byte characters or 3bytes characters) MySQL will allocate 3 bytes for every character so that column will be stored in 60bytes. If a and b are VARCHARs and c are CHARs that's it ! If you have all VARCHARs I'm in the dark ! Hope it helps ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
