hotcut — Sat, 27 Jan 2001 15:36:30 +0000

I don't know how much information there will be, so I better keep it as a text field.
Thanks anyway

If you want to see what I am using it for, here is the URL http://www.secretsofwar.net Just if you were curius.

~Casper

Peter J. Boettcher — Sat, 27 Jan 2001 15:27:34 +0000

Casper,

The text field is inefficient in two ways:

1) It requires more memory overhead than a char or varchar type field.

2) Indexing/Searching is slower through a text field compared to a char or varchar field.

If you know you're not going to exceed 6,000-8,000 characters I would recommend going with a varchar data type instead of text.

hotcut — Sat, 27 Jan 2001 12:40:23 +0000

By the way, what do you mean that they are not effecient? Is it just because that they are heavy in the data weight, or is there a more specifik reason?

hotcut — Sun, 14 Jan 2001 15:47:10 +0000

Thanks for that!

Peter J. Boettcher — Sat, 13 Jan 2001 16:42:52 +0000

Casper,

The memo field type in SQL is TEXT. So the statement would be:

ALTER TABLE Games ADD Game_Title TEXT NULL

Try not to use to many TEXT fields since they aren't super efficient.

hotcut — Sat, 13 Jan 2001 13:42:46 +0000

I ran into another problem regarding this!

I know wants to make a new row, that is in memo type, so that you can have ALL the data you wants in the cells.

How do I do that?

I suppose its something like:
ALTER TABLE Games ADD Game_Title VARCHAR(memo) NULL

But I aint sure on that... I REALLY hope that you can help me here!

Thanks in advance
Casper

hotcut — Wed, 10 Jan 2001 17:03:06 +0000

Tested it out, and it worked perfectly! Thanks a lot again! You spared my connection for a lot

See yóu
¨~Casper

hotcut — Wed, 10 Jan 2001 14:57:52 +0000

Thanks Peter

I will look at it, and see if I can make it work.

Kind regards
~Casper

Peter J. Boettcher — Wed, 10 Jan 2001 14:02:48 +0000

Casper,

I'm not sure which platform you're using but for Microsoft SQL 6.5-2000 the syntax is:

ALTER TABLE table_name
ADD column_name column_type value

for example:

ALTER TABLE Games ADD Game_Title VARCHAR(20) NULL

It's probably similar on other platforms.