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? Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/240575-enum-values-containing-quotes/#findComment-1237723 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.