Wouldn't it be the most portable solution to work with a domain?
CREATE DOMAIN BIG_NUMBER AS BIGINT;
If I use BIG_NUMBER everywhere I need it in my database, porting it to other database products should be easy... any SQL 92 compliant dbms should support domains.
On Sun, 2003-09-28 at 00:06,
Yusuf W. [EMAIL PROTECTED] writes:
For the application that I'm working on, we want to
use data types that are database independent. (most
databases has decimal, but not big int).
Most databases have bigint, I think.
Anyhow, we are planning on using decimal(19,0) for our
primary keys
Now, I've got to convince my project's software
architech, that a bigint would be better than a
decimal.
Does anyone know where I could get some documentation
on how the int and decimal are implemented so I could
prove to him that ints are better? Can people suggest
good points to make in
Yusuf,
Does anyone know where I could get some documentation
on how the int and decimal are implemented so I could
prove to him that ints are better? Can people suggest
good points to make in order to prove it?
RTFM: