Re: Int(4) or int(8)

[Yves Goergen]

On 09.03.2007 17:12 CE(S)T, Bruno Rodrigues Silva wrote:
 I understand that theses values are unrelated to the range of
 datatype values, however i did not saw any diference when i use
 int(4) or int(8)
 
 Some idea?

Isn't it a bit useless to specify the visual, decimal length of a
numeric data type that's internally stored in bits? I never specify a
length of a number, but use SMALLINT, INT etc instead. If my INT field
holds a value that takes 6 digits in decimal, what should be the output
if the column was declared INT(3)? Is it allowed to drop some data?

(Resending because the list wasn't added to the recipients.)

-- 
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Int(4) or int(8)

[Bruno Rodrigues Silva]

hi all

The mysql manual inform that: 

EX. century int(4)

The result is that values in the century column usually are
displayed four digits wide. However, its important to undesrstand that the
display width is unrelated to the range of the datatype. The display
width specified for a column affects ONLY the maximum number of
digits MySQL uses to DISPLAY column values.

I understand that theses values are unrelated to the range of datatype values, 
however i did not saw any diference when i use int(4) or int(8)

Some idea?

Regards

Bruno



__
Fale com seus amigos  de graça com o novo Yahoo! Messenger 
http://br.messenger.yahoo.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]