Hi, On Fri, Apr 4, 2008 at 1:46 PM, Ed W <[EMAIL PROTECTED]> wrote: > It appears that since updating from mysql 5.0.44 to 5.0.54 I have also lost > my DEFAULT "" option on all my varchar columns. > > For colums which are also NOT NULL this is causing a bunch of problems in > my existing app (trying to insert NULLS) > > Anyone can explain what happened and why this has changed? Innodb if this > makes a difference..
What upgrade process did you follow? Did you just upgrade MySQL, or did you dump and reload your data somehow? Check the release notes for all the intervening versions, but I doubt this is supposed to happen. It may be a bug. -- Baron Schwartz, Senior Consultant, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]