Re: mysql InnoDB table creation problem

2007-03-28 Thread Boyd Hemphill
Depending on the version you use MySQL will see a definition of varchar(25) as 25 bytes or 25 characters. I believe this changed from 4.1 to 5.0 respectively but I am not sure. THis could be the root of the problem Boyd CONFIDENTIALITY NOTICE: This email & attached documents may conta

Re: mysql InnoDB table creation problem

2007-03-26 Thread Joshua Marsh
On 3/26/07, Anil D <[EMAIL PROTECTED]> wrote: Varchar = 0 bytes I don't think this is right, see below. Charset used: UTF8 UTF8 means that some characters may be two bytes, see below. Note: When consider even the size Varchar(m) = m+1 bytes, the size of row has reached 35,000 bytes.