5 Replies - 1363 Views - Last Post: 14 July 2013 - 02:40 PM Rate Topic: -----

#1 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 795
  • View blog
  • Posts: 1,681
  • Joined: 30-January 09

Boolean datatype is so last decade

Posted 07 July 2013 - 08:59 PM

An application I am helping with had it's database designed by a coder who has now been ushered out of the building. Amongst his data schema greats, here's a table he created as a lookup:
TABLENAME: YesNos
ID   Description
--   -----------
1    Yes
2    No


I think he may have been working on an integers table too, but couldn't work out how to get around the infinite rows issue.
Is This A Good Question/Topic? 0
  • +

Replies To: Boolean datatype is so last decade

#2 Adam27X  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 13-July 13

Re: Boolean datatype is so last decade

Posted 13 July 2013 - 08:49 PM

While this table is quite silly, I don't see the issue with a language implementing a boolean data type. Care to elaborate?
Was This Post Helpful? 0
  • +
  • -

#3 Witchking  Icon User is offline

  • D.I.C Head

Reputation: 68
  • View blog
  • Posts: 188
  • Joined: 17-February 13

Re: Boolean datatype is so last decade

Posted 14 July 2013 - 07:29 AM

I believe OP was being sarcastic.
Was This Post Helpful? 0
  • +
  • -

#4 andrewsw  Icon User is offline

  • Fire giant boob nipple gun!
  • member icon

Reputation: 3488
  • View blog
  • Posts: 11,902
  • Joined: 12-December 12

Re: Boolean datatype is so last decade

Posted 14 July 2013 - 07:44 AM

He should have used 0 for No :rolleyes2:
Was This Post Helpful? 0
  • +
  • -

#5 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 795
  • View blog
  • Posts: 1,681
  • Joined: 30-January 09

Re: Boolean datatype is so last decade

Posted 14 July 2013 - 02:28 PM

He shouldn't have had a lookup database table at all, a bit datatype would have sufficed
Was This Post Helpful? 1
  • +
  • -

#6 andrewsw  Icon User is offline

  • Fire giant boob nipple gun!
  • member icon

Reputation: 3488
  • View blog
  • Posts: 11,902
  • Joined: 12-December 12

Re: Boolean datatype is so last decade

Posted 14 July 2013 - 02:40 PM

View Poste_i_pi, on 14 July 2013 - 09:28 PM, said:

He shouldn't have had a lookup database table at all, a bit datatype would have sufficed

Of course, I was attempting to be witty ;)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1