RE: Varchar limit warning - similar question

2007-01-05 Thread Jerry Schwartz
l Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Olaf Stein [mailto:[EMAIL PROTECTED] > Sent: Friday, January 05, 2007 2:26 PM > To: Jerry Schwartz > Subject: Re: Varchar limit warning - simila

RE: Varchar limit warning - similar question

2007-01-05 Thread Jerry Schwartz
06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Olaf Stein [mailto:[EMAIL PROTECTED] > Sent: Friday, January 05, 2007 1:52 PM > To: [EMAIL PROTECTED] > Cc: MySql > Subject: Re: Varchar limit warning - similar question > > Thanks > That works nicely

Re: Varchar limit warning - similar question

2007-01-05 Thread Olaf Stein
Sorry, wrong example For instance, it makes no difference regarding the values I can enter if I declare a field as int or int(3) On 1/5/07 1:52 PM, "Olaf Stein" <[EMAIL PROTECTED]> wrote: > Thanks > That works nicely. > > Why does that not have any effect with numeric values. > E.g. I can inse

Re: Varchar limit warning - similar question

2007-01-05 Thread Olaf Stein
Thanks That works nicely. Why does that not have any effect with numeric values. E.g. I can insert the same max numbers in a tinyint column then in a tinyint(1) column, For example, how do I create a column that only allows 1 numeric value from 0 to 5? Thanks Olaf On 1/5/07 12:52 PM, "[EMAIL