Return-Path: Received: (majordomo@vger.kernel.org) by vger.kernel.org via listexpand id S262791AbVDHMVj (ORCPT ); Fri, 8 Apr 2005 08:21:39 -0400 Received: (majordomo@vger.kernel.org) by vger.kernel.org id S262794AbVDHMVj (ORCPT ); Fri, 8 Apr 2005 08:21:39 -0400 Received: from mail.enyo.de ([212.9.189.167]:22193 "EHLO mail.enyo.de") by vger.kernel.org with ESMTP id S262791AbVDHMVh (ORCPT ); Fri, 8 Apr 2005 08:21:37 -0400 From: Florian Weimer To: Kernel Mailing List Subject: Re: Kernel SCM saga.. References: <20050408041341.GA8720@taniwha.stupidest.org> <20050408071428.GB3957@opteron.random> <20050408120244.GB10129@merlin.emma.line.org> Date: Fri, 08 Apr 2005 14:21:34 +0200 In-Reply-To: <20050408120244.GB10129@merlin.emma.line.org> (Matthias Andree's message of "Fri, 8 Apr 2005 14:02:44 +0200") Message-ID: <87fyy1bgs1.fsf@deneb.enyo.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Sender: linux-kernel-owner@vger.kernel.org X-Mailing-List: linux-kernel@vger.kernel.org Content-Length: 981 Lines: 20 * Matthias Andree: >> commiter_name VARCHAR(32) NOT NULL CHECK(commiter_name != ''), >> commiter_email VARCHAR(32) NOT NULL CHECK(commiter_email != ''), > > The length is too optimistic and insufficient to import the current BK > stuff. I'd vote for 64 or at least 48 for each, although 48 is going to > be a tight fit. It costs a bit but considering the expected payload > size it's irrelevant. You should also check your database documentation if VARCHAR(n) is actually implemented implemented in the same way as TEXT (or what the unbounded string type is called), plus an additional length check. It doesn't make much sense to use VARCHAR if there isn't a performance (or disk space) benefit, IMHO, especially for such data. - To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/