topic-28295

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

MySQL fieldlength question
Posted: Tue Apr 08, 2014 10:49 AM

Hello,

I have a field in a table defined as integer, length 7.
I see that I can fill a number with more than digits into that field.
Is this normal?

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: MySQL fieldlength question
Posted: Tue Apr 08, 2014 01:07 PM

Marc,

Marc Vanzegbroeck wrote:Hello,

I have a field in a table defined as integer, length 7.
I see that I can fill a number with more than digits into that field.
Is this normal?

Yes, if you are using field types other than NUMERIC. With NUMERIC type you can specify lenght and decimals, just like with DBF.

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

FiveTech Support Forums

Continue the discussion