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? Link to comment https://forums.phpfreaks.com/topic/350-compatibility-with-enum-in-msql/ 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. Link to comment https://forums.phpfreaks.com/topic/350-compatibility-with-enum-in-msql/#findComment-1125 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. Link to comment https://forums.phpfreaks.com/topic/350-compatibility-with-enum-in-msql/#findComment-1127 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.