• (cs)

    SQL's money type was and is a mistake by the database vendors. It does goofy rounding and truncating when you use it in division. Numeric/Decimal is the SQL standard and is universally supported and thus is the correct choice.

  • in PT (unregistered) in reply to Andrew
    Andrew:
    2. US zip codes are longer than most other countries so this should be OK
    8 in Portugal: 4 digits a hyphen and 3 more digits. No reason to put this in any table without the country. Likewise state/region without the country makes little sense. I wonder how long must those codes be in the Holy See.
  • Jobsworth (unregistered) in reply to RocketRick
    RocketRick:
    A Gould:
    TallGuy:
    Wait...what's Canada, then? A foreign country?!

    <ob.CanadianPatriotism> Look up - we're larger than you, and on top. </ob>

    If God had wanted us to think Canada was bigger, he wouldn't have given us the Mercator projection, eh?

    • Rick
    Actually, that would have been Gerard De Cremer, not some invisible pink unicorn or a flying spaghetti monster or other member of the fictional pantheon of your preference.

    Yeah I'm proud of our most famous cartographer. He lived and worked only 12km from where I live, until he moved to Germany after charges of heresy. Saying that "God" had anything to do with his maps is quite ironic...

  • Jobsworth (unregistered) in reply to Monkios
    Monkios:
    frustrati:
    Monkios:
    Canada is my country. Quebec is where I live.
    In that case, you must provide all of your posts in French at a minimum. If you choose to post in both French and English, the French version must be displayed more prominently than the English one.
    Tu as raisons.

    À partir de maintenant, j'essaierai de faire ce que tu as proposé.

    You are right.

    From now on, I will try to do what you sugested.

    Ik veronderstel dat "raison[i]s[i]" geen Frans is maar Québécois? Je suppose que "raison[i]s[i]" n'est pas Français mais Québécois?

    (and those 70.000 German speakers in the east can go sit on their thumb, even if they have a Minister-President who is also a Royal Negotiator)

  • Jobsworth (unregistered)

    The Real WTF is that by now there are about 10 people who noticed the Aussi states.

    Captcha: erat

  • Phiu-x (unregistered) in reply to Andrew
    Andrew:
    Former Junior Programmer:
    TallGuy:
    Wait...what's Canada, then? A foreign country?!

    The 51st state.

    Almost, Lower Canada, now Ontario, was asked to join the revolution. It would have been the 14th state, not the 51st.

    Ummm no.

    Lower Canada was the actual province of Quebec. Upper Canada (Ontario) was and still is loyalist.

    Oh and In the early 1800's the Americans again asked us Quebecers to join them against upper Canada and we refused. Again during the 1837 troubles, we asked the Americans to help us and than they refused!

    History man history ...

  • (cs) in reply to Charles400
    Charles400:
    Cardinal rule II: Don't CC the bosses on this type of dialogue.

    I've worked on a project where the team leader insisted on getting a copy of every single email the developers sent to each other.

  • Steve Bennett (unregistered)

    So who's at fault here? I don't get it. The junior dev's comment seems reasonable:

    Please note that existing data has many states like ACT, NSW, QLD etc which are all 3 characters.

    Emphasis on existing data. If he has to deal with 3 character states, then clearly 2 character state fields are insufficient?

    Steve

  • Steve Bennett (unregistered)

    in Chareths defence, ACT, NSW and QLD are states. in Australia. ACT = Australian Capital Territory

    The ACT isn't a state...

    Steve

  • Sikon (unregistered) in reply to Uber

    Ahem, could we avoid ethnic jokes?

    // A Russian

  • J. B. Rainsberger (unregistered)

    If existing data for state really did include ACT, NSW, QLD, then could it be the existing data was for, um, Australian customers? Australian Capital Territory, New South Wales, and Queensland, perhaps?

  • J. B. Rainsberger (unregistered) in reply to J. B. Rainsberger

    Yes, I am a dick. I didn't read the other comments before I wrote my incredibly stupid one. Shoot me.

  • Sergxpx (unregistered)

    Do you know what holiday it is today? We are used to the fact that we know only religious and public holidays and celebrate only them. I found out about this only yesterday after visiting the site https://whenisholiday.com/. It turns out that every day there are from 2 to 10 different holidays that surround us and make our lives happier. Here is one of the holidays that will be today: https://whenisholiday.com/america/when-is-national-law-enforcement-day-2018.htmlhttps://whenisholiday.com/america/when-is-national-crush-day-2018.htmlhttps://whenisholiday.com/america/when-is-national-send-nudes-day-2018.htmlhttps://whenisholiday.com/world/when-is-world-snake-day-2017.htmlhttps://whenisholiday.com/america/when-is-national-no-panty-day-2018.htmlhttps://whenisholiday.com/world/when-is-national-teacher-appreciation-day-2017.htmlhttps://whenisholiday.com/america/when-is-last-day-of-chanukah-2017.htmlhttps://whenisholiday.com/australiahttps://whenisholiday.com/world/when-is-st-nicholas-day-2017-2.htmlhttps://whenisholiday.com/america/when-is-national-teddy-bear-picnic-day-2017.html

Leave a comment on “Rule Number One”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article