Author Topic: Setting default database datatype  (Read 192 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 6041
  • Karma: +73/-83
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Setting default database datatype
« on: March 11, 2007, 10:09:33 pm »
Before I report a bug, does anyone know how to set a default database column datatype (such as you can with code languages Default Attribute Type - using Tools|Options|Source Code Engineering|<language>)

EA seems to take the first item on the list - which in Oracle's case is BFILE - as useful as the proverbial...

TIA,
Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Setting default database datatype
« Reply #1 on: March 12, 2007, 03:12:32 am »
Quit carping Paolo, the answer is obvious.

For each column, just choose the DBMS with the closest data type to the one you need at the beginning of the alphabet.

Why else would we have multiple DBMS selections anyway?

[Alternatively, I suppose Sparx could provide a different solution. Still, that would require us to set a default type, probably without even getting a (substantial) raise for the increased work load, stress, danger, etc.]
No, you can't have it!