Announcement

Collapse
No announcement yet.

Very strange behaviour in primary key field!!

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Very strange behaviour in primary key field!!

    I have a table with a primary key field (Code) type (int(11)), value insert manually.
    When i insert this value: 30201010 it goes well and saved without any problem, When i insert 3020101010 the data saved but the number in the primary key field changed to 2147483647 !!!!
    So 3020101010 will be 2147483647 after record save

    Please help ...
    Scriptcase V8.1 Enterprise Edition.

  • #2
    Because its the max positive number for a signed int.
    http://en.m.wikipedia.org/wiki/Integ...puter_science)
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      Thanks so much (Giu). Appreciate your help.
      Scriptcase V8.1 Enterprise Edition.

      Comment

      Working...
      X