MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Using an ENUM column in an index
Posted by: Tom Byars
Date: March 16, 2015 09:48AM

PS I know if you sort on an enum column they're returned in order of their numeric values so I'm guessing the index mentioned above would store the numeric values rather than the strings. I'm sure I read though that at some point in the future MySQL intended to change this behaviour such that an enum field would be sorted on its string values. If that changeover occurs what would the index store then?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Using an ENUM column in an index
Tom Byars
March 16, 2015 09:18AM
Re: Using an ENUM column in an index
Tom Byars
March 16, 2015 09:48AM
Re: Using an ENUM column in an index
Peter Brawley
March 16, 2015 10:50AM
Re: Using an ENUM column in an index
Tom Byars
March 17, 2015 07:49AM
Re: Using an ENUM column in an index
Peter Brawley
March 17, 2015 10:39AM
Re: Using an ENUM column in an index
Rick James
March 17, 2015 10:16PM
Re: Using an ENUM column in an index
Tom Byars
March 18, 2015 01:58AM
Re: Using an ENUM column in an index
Tom Byars
March 18, 2015 05:53AM
Re: Using an ENUM column in an index
Peter Brawley
March 18, 2015 10:08AM
Re: Using an ENUM column in an index
Rick James
March 18, 2015 06:12PM
Re: Using an ENUM column in an index
Tom Byars
March 19, 2015 05:15AM
Re: Using an ENUM column in an index
Peter Brawley
March 19, 2015 11:16AM
Re: Using an ENUM column in an index
Rick James
March 19, 2015 11:39PM
Re: Using an ENUM column in an index
Tom Byars
March 20, 2015 02:24AM
Re: Using an ENUM column in an index
Tom Byars
March 18, 2015 01:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.