On 7/28/07, PaulCheung <[EMAIL PROTECTED]> wrote:
> When I set the table up I set the LICENCE to INT(8). When populating this
> field I was expecting any number larger than 8 digits to be truncated and
> any number less than 8 digits to be padded out with zeros, in both cases
> this is not happeni
On July 28, 2007, PaulCheung wrote:
When I set the table up I set the LICENCE to INT(8). When populating this
field I was expecting any number larger than 8 digits to be truncated and
any number less than 8 digits to be padded out with zeros, in both cases
> this is not happening.
Random
Hi Mike,
Thank you for pointing me in the right direction. My problem was
mis-understanding what INT(8) meant.
Paul
- Original Message -
From: "Michael Sims" <[EMAIL PROTECTED]>;
To: "NYPHP Talk"
Sent: Saturday, July 28, 2007 7:36 PM
Subject: Re: [ny
On July 28, 2007, PaulCheung wrote:
> When I set the table up I set the LICENCE to INT(8). When populating this
> field I was expecting any number larger than 8 digits to be truncated and
> any number less than 8 digits to be padded out with zeros, in both cases
> this is not happening.
Nope. An
PaulCheung wrote:
I created a MySQL database with tables. In one of the tables, the
Customer Name& Address table, I use as the PRIMARY KEY a numeric field
that I call LICENCE which is a number generated through a random number
generator.
When I set the table up I set the LICENCE to INT(8). Wh
I created a MySQL database with tables. In one of the tables, the Customer
Name& Address table, I use as the PRIMARY KEY a numeric field that I call
LICENCE which is a number generated through a random number generator.
When I set the table up I set the LICENCE to INT(8). When populating this
