• Brandie Tarvin (9/5/2012)


    CELKO (9/5/2012)


    we do not use FLOAT in SQL because of rounding errors and the laws concerning currency.

    You keep saying this, but I work (and have worked) with multiple companies that do use FLOAT (and use it quite well) because the other data types don't give them the information they need. The waste management industry, for instance, needs it to calculate tonnage and other items.

    Some people even use FLOAT for financial transactions.

    So I have two questions for you.

    1) Who is "we"?

    2) What currency laws are you referring to? Because if I'm breaking laws by supporting these databases, I'd really like to know before I end up in jail for the rest of my life.

    1) Who is "we"?

    Mr. Celko and his pet mouse (the one he keeps in his shirt pocket, you know, the one with the pocket protector).

    2) What currency laws are you referring to? Because if I'm breaking laws by supporting these databases, I'd really like to know before I end up in jail for the rest of my life.

    You have me on this one. My Google-fu fails on finding anything.