yes, some do end in 'x' as I just discovered. Thanks to everyone for
the input, I have decided to convert to varchar and re-index.
Keith C. Ivey wrote:
On 5 Aug 2003 at 9:49, Eben Goodman wrote:
The data type of the field I am
storing this info in is a bigint(16) unsigned. It appears tha
Eben.
Yes, use a character based data type as the leading zero's are insignificant
and will be removed.
HTH
Kev.
> --
> From: Eben Goodman
> Sent: Tuesday, August 5, 2003 14:49 PM
> To: [EMAIL PROTECTED]
> Subject: storing large integers proper
t;
Gesendet: Dienstag, 5. August 2003 15:49
Betreff: storing large integers properly
> I am storing book isbn numbers in a table. isbn numbers are 10 digit
> numbers and many start with 0. The data type of the field I am storing
> this info in is a bigint(16) unsigned. It appears tha
Eben Goodman wrote:
I am storing book isbn numbers in a table. isbn numbers are 10 digit
numbers and many start with 0. The data type of the field I am storing
this info in is a bigint(16) unsigned. It appears that isbns that start
with 0 are going in as 9 digit numbers, the 0 is being ignor
On 5 Aug 2003 at 9:49, Eben Goodman wrote:
> The data type of the field I am
> storing this info in is a bigint(16) unsigned. It appears that isbns
> that start with 0 are going in as 9 digit numbers, the 0 is being
> ignored or stripped. I have experienced this before with integer data
> types
* Eben Goodman
> I am storing book isbn numbers in a table. isbn numbers are 10 digit
> numbers and many start with 0. The data type of the field I am storing
> this info in is a bigint(16) unsigned.
Why not use "BIGINT(10) UNSIGNED ZEROFILL"?
> It appears that isbns that start
> with 0 are goi
I am storing book isbn numbers in a table. isbn numbers are 10 digit
numbers and many start with 0. The data type of the field I am storing
this info in is a bigint(16) unsigned. It appears that isbns that start
with 0 are going in as 9 digit numbers, the 0 is being ignored or
stripped. I h
How about BIGINT(10) ZEROFILL ?
Eben Goodman wrote:
I am storing book isbn numbers in a table. isbn numbers are 10 digit
numbers and many start with 0. The data type of the field I am
storing this info in is a bigint(16) unsigned. It appears that isbns
that start with 0 are going in as 9 di