sleepingpeace Posted June 28, 2011 Share Posted June 28, 2011 I'm trying to use MySQL to insert some values for an enum column. The values contain height measured in feet and inches such as 6'2". Problem is that it contains the single and double quotes and doesn't quite work the way I'd like. So I tried entering a value of '6''2"' or '6\'2\"' and neither work... Who's got the answer to this one? Link to comment https://forums.phpfreaks.com/topic/240575-enum-values-containing-quotes/ Share on other sites More sharing options...
sleepingpeace Posted June 28, 2011 Author Share Posted June 28, 2011 Nevermind, just going with varchar. I guess numbers in an enum data type isn't the greatest idea. Link to comment https://forums.phpfreaks.com/topic/240575-enum-values-containing-quotes/#findComment-1235732 Share on other sites More sharing options...
fenway Posted July 2, 2011 Share Posted July 2, 2011 Height as an ENUM field? Bad idea. Height as a VARCHAR? Bad idea. Link to comment https://forums.phpfreaks.com/topic/240575-enum-values-containing-quotes/#findComment-1237723 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.