Jump to content


Photo

compatibility with enum in m$sql


  • Please log in to reply
2 replies to this topic

#1 WormTongue

WormTongue
  • Members
  • PipPip
  • Member
  • 13 posts
  • LocationIllinois

Posted 14 April 2003 - 05:18 PM

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?
WHOHOO! I am now a Forum Regular!! :)

#2 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 14 April 2003 - 07:10 PM

MS SQL does not have an ENUM data type.. I\'ve responded to your other thread here : http://forums.phpfre...opic.php?t=3272

Hope that helps.

#3 WormTongue

WormTongue
  • Members
  • PipPip
  • Member
  • 13 posts
  • LocationIllinois

Posted 14 April 2003 - 07:12 PM

yea, i just saw that. Thanks for your help. :D
WHOHOO! I am now a Forum Regular!! :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users