smilm | Salut!
J'aimerais des informations sur le type BIGINT de MYSQL, sur la doc officiel il y'a beaucoup de commentaires dessus, mais je capte pas tout.
Code :
- BIGINT[(M)] [UNSIGNED] [ZEROFILL]
- A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615. Some things you should be aware of with respect to BIGINT columns:
- All arithmetic is done using signed BIGINT or DOUBLE values, so you shouldn't use unsigned big integers larger than 9223372036854775807 (63 bits) except with bit functions! If you do that, some of the last digits in the result may be wrong because of rounding errors when converting the BIGINT to a DOUBLE. MySQL 4.0 can handle BIGINT in the following cases:
- Use integers to store big unsigned values in a BIGINT column.
- In MIN(big_int_column) and MAX(big_int_column).
- When using operators (+, -, *, etc.) where both operands are integers.
- You can always store an exact integer value in a BIGINT column by storing it as a string. In this case, MySQL will perform a string-to-number conversion that involves no intermediate double representation.
- `-', `+', and `*' will use BIGINT arithmetic when both arguments are integer values! This means that if you multiply two big integers (or results from functions that return integers) you may get unexpected results when the result is larger than 9223372036854775807.
|
J'aurais bien besoin d'un BIGINT, mais cela pose t'il de reel problemes ?
Merci d'avance. ---------------
AfterEnd: Batissez un nouveau monde
|
