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/
