remember you can group on a varchar column that's larger than.. bum, I've forgotten - but its something like 3000 or so.
/me starts digging through sqlbol to try and fins the number... > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 08 January 2004 09:50 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Database Question (SQL) > > > If its SQL Server : None....a Varchar Datatype in SQL Server > can hold up to > 8000. When the rows begin to grow with more data : so will > your database > size. > > Increasing a datatype size will have no detrimental effect on > your system - only decreasing it will. > > -----Original Message----- > From: Allan Cliff [mailto:[EMAIL PROTECTED] > Sent: 08 January 2004 09:09 > To: CF - List > Subject: [ cf-dev ] Database Question (SQL) > > If I have a varchar field which is 255 characters what are > the consequences of upping this to say 500. > > > Thanks > Allan > This e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a > division of Reed Business, Registered in England, Number > 678540. It contains information which is confidential and > may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note that any form of distribution, > copying or use of this communication or the information in it > is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call our switchboard on +44 (0) 20 89107910. The > opinions expressed within this communication are not > necessarily those expressed by Reed Exhibitions. Visit our > website at http://www.reedexpo.com > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
