[aur-dev] [PATCH] Use VARCHAR instead of CHAR where appropriate.

Dan McGee dpmcgee at gmail.com
Tue Feb 8 22:13:07 EST 2011


On Tue, Feb 8, 2011 at 8:31 PM, Loui Chang <louipc.ist at gmail.com> wrote:
> On Tue 08 Feb 2011 10:40 +0100, Lukas Fleischer wrote:
>> -     LangPreference CHAR(5) NOT NULL DEFAULT 'en',
>
> I think LangPreference could probably remain at CHAR, but I am no i18n
> or DB whiz.

If it isn't something that must be X characters, it makes more sense
to use varchar. In this case, we can see that the default is only 2
chars, so varchar seems appropriate to me.

-Dan


More information about the aur-dev mailing list