Thanks all, So varchar better than text because: a) can be indexed b) takes up less space
Cheers, Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pat Branley Sent: Thursday, 2 June 2005 11:53 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Database fields best practice for SQL server at least: Am I right in saying that it doesnt so much about setting a small size for varchar fields. ie. varchar(100) will only take up as much space as the value of the attribute's data. however char(100) will allways take 100 characters. then having said that you cant just go silly and set everthing to varchar(1000) because you only get something like 8000 characters per record ? This is Excluding text & blob types which are stored outside the record and hence cannot be used to index the record ? Pat M@ Bourke wrote: >>Just wondering... > > Don't you'll give your self a headache > > >>What's better for a name - tinytext or varchar(20) - or doesn't it matter. > > a lot of names would be longer then 20 chars > set it to atleast double that. > > >>And what's the difference between a blob field and a text field? > > BLOB stands for binary large object ??? > its for large binary objects like images etc. > > M@ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ NOTICE: Medical and scientific information provided in print and electronically by Sydney IVF might not be relevant to your own circumstances and should always be discussed with your own doctor before you act on it. This communication is confidential and may contain copyright or otherwise protected information of Sydney IVF Limited or a third party. If you are not the intended recipient of this communication please immediately let us know by reply email or telephone us on +61 2 9221 5964, delete the communication and destroy all copies. --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
