Re: Default 2147483647

A waste of electrons? You decide, but Message-ID:
<1130245491.083245.257190@g47g2000cwa.googlegroups.com> from Oli Filth
contained the following:

>If you insert 001234 into an int type, it stores 1234, because that's
>the integer value.
>
>You'll want to use a character-based type, e.g. VARCHAR(x).

I wish I had a £ for every time a student had made that mistake :-}

-- 
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/