|
|
Posted by Kim Andrι Akerψ on 10/25/05 16:11
Faree wrote:
> Hi all,
>
> I am doing portal for storing info of visitors.it is working well
> too.but my prob is with mysql..when i entered infoa bt thier phone
> numbers ,fax or mobile numbers,soemtimes it is storing 2147483547
> instead of given number or default null.can u tell me the reason and
> solution for it.
2147483647 is the maximum value for a signed integer, as per the MySQL
manual.
http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
I'd choose a different field type, or at least one that can account for
larger numbers.
--
Kim AndrΓ© AkerΓΈ
- kimandre@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)
Navigation:
[Reply to this message]
|