Correct data types?

Dev Shed Forums Sponsor:

September 17th, 2012, 06:23 AM

badger_fruit

Confused badger

Join Date: Mar 2009

Location: West Yorkshire

Posts: 760

Time spent in forums: 1 Week 4 Days 5 h 15 m 18 sec
Reputation Power: 339

Correct data types?

Hello all
I usually foul-up, sorry, post my questions in the PHP forum but today I have a MySQL Database question; probably a very easy one for you DB masters ... What are the correct data-types I should be using to store these values (this is a dump of a PHP array):-

Array
(
[date] => 16/09/2012
[time] => 15:30:46
[anumber] => 1109907096175000
[bnumber] => VOIP
[origin] => 650
[dialled]=> 440906001002
[destination] => 323
[duration] => 313
[cost] => 0.1050
)

Thanks for any help
Regards

A Total Noob lol

__________________
The number for UK Emergencies is changing, the new number is 0118 999 881 999 119 7253

"For if leisure and security were enjoyed by all alike, the great mass of human beings who are normally stupefied by poverty would become literate and would learn to think for themselves; and when once they had done this, they would sooner or later realise that the privileged minority had no function and they would sweep it away"
- George Orwell, 1984

September 17th, 2012, 07:31 AM

deljr

Contributing User

Join Date: Jun 2012

Location: Wisconsin

Posts: 78

Time spent in forums: 1 Day 11 h 51 m 6 sec
Reputation Power: 1

[date] => 16/09/2012
[time] => 15:30:46

those could be condensed into a single column with a datetime data type

[anumber] => 1109907096175000
[bnumber] => VOIP
[origin] => 650
[dialled]=> 440906001002
[destination] => 323
[duration] => 313
[cost] => 0.1050

as for the rest what are you using now?

September 17th, 2012, 07:55 AM

bobhairgrove

Registered User

Join Date: Sep 2012

Posts: 6

Time spent in forums: 1 h 28 m 40 sec
Reputation Power: 0

Code:

[date] => 16/09/2012
    [time] => 15:30:46

Are these actually just one timestamp? As already mentioned, you could use DATETIME. There is also the TIMESTAMP column type which allows for a default value of NOW() or CURRENT_TIMESTAMP(). If not related, then you can use the DATE and TIME data types instead.

Code:

[anumber] => 1109907096175000
    [bnumber] => VOIP

These both look like they should be stored as text, i.e. VARCHAR(n) where n = the largest possible number of characters. This is especially true if the numbers might contain leading zeros.

Code:

[origin] => 650

Is this a foreign key of some kind to a related table? If so, it should be the same data type as in the referred table, probably some kind of integer.

Code: