20 Mar 2009

[Rant] Oracle and the Boolean Type

A long time ago I used Oracle (I think it was something like 7 or 8 version)... there was no boolean type at that time, ok.

Then I mainly used SqlServer, MySql and PostgreSql.
They all have some sort of boolean type:
How is it possible that a database costing $40 000 per cpu, DOESN'T HAVE A BOOLEAN TYPE!! (and they have boolean in plsql!)

Apparently you need to use an number(1) to store those kind of values... How lame!

And don't get me started on the auto-increment columns ;)

1 comment:

Mickael said...

I always used an integer, whatever the DB was. No problem with that.