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.

Re: Functions and NULL with standard install

2007-03-21 Thread Joshua Marsh
On 3/21/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I am running a basic install of MySQL 5.0 with strict mode turned on I would like to use RPAD however at times a NULL var will be sent to the function. My goal is to have a function that will convert the NULL to a blank string to get the