itzumar
Posts: 88
|
Posted: 05/13/2013, 4:34 AM |
|
Dear sir!
i have record form in code charge studio using php and mysql.
when i enter 13 digit integer in record from. than last digit become 0 . for example
i enter following in record form
8220311850545
and mysql store as follow
8220311850540
plz help me. i will be very thankful to you
_________________
Umar |
|
|
mor
Posts: 119
|
Posted: 05/13/2013, 8:49 AM |
|
http://dev.mysql.com/doc/refman/5.5/en/integer-types.html
INT or INTEGER:
The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295
You can use BIGINT type (The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615).
_________________
Mor ve Ötesi |
|
|
Lucius
Posts: 220
|
Posted: 05/13/2013, 9:45 AM |
|
Also to add to what mor wrote:
CCS as far as I can see supports only normal "Integer" property for the record field. So if you get unpredictable results after you fix the field type in the DB, use "Text" property. It will work, instead of query looking like:
SELECT something FROM table WHERE id = 123456
It will look like
SELECT something FROM table WHERE id = '123456'
Works basically the same, but usually will be bit slower (how much depends on DB), as there will be internal DB text to bigint conversion.
|
|
|
|