List:General Discussion« Previous MessageNext Message »
From:Chris Bolt Date:October 21 2001 2:31am
Subject:RE: Length limit of 500 on primary keys?
View as plain text  
> Is there a way to raise this limit? We have some tables with columns that
> are VARCHAR(200), and need to make a primary key based on combinations of
> these columns (in some cases, upto 4 columns), and MySQL complains for all
> of these table definitions that "Specified key was too long. Max key
> length is 500".

Why do you need to index the entire column? You can just index a prefix of
the column, like the first 125 bytes of each column.

Thread
Length limit of 500 on primary keys?Shankar Unni21 Oct
  • RE: Length limit of 500 on primary keys?Chris Bolt21 Oct
    • RE: Length limit of 500 on primary keys?Steve Meyers21 Oct
      • Re: Length limit of 500 on primary keys?Shankar Unni22 Oct
        • RE: Length limit of 500 on primary keys?Steve Meyers22 Oct
          • Re: Length limit of 500 on primary keys?Jeremy Zawodny23 Oct
            • RE: Length limit of 500 on primary keys?Steve Meyers23 Oct
              • RE: Length limit of 500 on primary keys?Steve Meyers23 Oct
                • Re: Length limit of 500 on primary keys?Shankar Unni24 Oct
              • Re: Length limit of 500 on primary keys?Bill Adams23 Oct
                • RE: Length limit of 500 on primary keys?Steve Meyers23 Oct
              • RE: Length limit of 500 on primary keys?Don Read23 Oct
            • Re: Length limit of 500 on primary keys?Dan Nelson24 Oct
Re: Length limit of 500 on primary keys?Heikki Tuuri23 Oct