WormTongue Posted April 14, 2003 Share Posted April 14, 2003 I am trying to create a table and i have the code for mysql, but i need it in m$sql. If i run the same code, i get errors and i think i have found the error. Does the data type \"enum\" work in m$sql? Here is the sample from my code: user_level enum(\'0\',\'1\',\'2\',\'3\') NOT NULL default \'0\', Now, i get an error on this line and i\'m thinking that mssql doesn\'t recognize the enum data type. Any ideas? Quote Link to comment Share on other sites More sharing options...
metalblend Posted April 14, 2003 Share Posted April 14, 2003 MS SQL does not have an ENUM data type.. I\'ve responded to your other thread here : http://forums.phpfreaks.com/viewtopic.php?t=3272 Hope that helps. Quote Link to comment Share on other sites More sharing options...
WormTongue Posted April 14, 2003 Author Share Posted April 14, 2003 yea, i just saw that. Thanks for your help. Quote Link to comment 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.