DBTools Software - Forums

Anonymous

Home » Forums » DBManager General

Meaning of Size in Table Editor? (872 previews)
Meaning of Size in Table Editor?	Posted in 17th, 11/2004 02:01 by arr242
In the Table Editor I have a row called Price of type Decimal Size is 3 and Decimals is 2 and the Null box is checked. Does Size mean the total number of digits in the number? Also does the check mark in the Null box mean NULLs are allowed as values in the field? I have assumed that is what it means. Alan Windows XP Home SP2 MySQL 4.1.7 DBManager 3.0
Re: Meaning of Size in Table Editor?	Posted in 17th, 11/2004 05:12 by support
Hi Alan, *arr242 wrote:* In the Table Editor I have a row called Price of type Decimal Size is 3 and Decimals is 2 and the Null box is checked. Does Size mean the total number of digits in the number? Usually this property is used to set the field size but it is dependent of the database engine. For example for MySQL when you set size for a number it is used to specify the size of the number in digits. In your example that would be Size 3, and Decimals 2 to get Decimal(3,2). *arr242 wrote:* Also does the check mark in the Null box mean NULLs are allowed as values in the field? I have assumed that is what it means. Alan Yes, when marked the field accept NULL values. Hope that hhelps, Support / DBTools Software
Meaning of Size in Table Editor? (872 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » DBManager General