Newbie question that maybe should belong in a mysql group, but how and why
does a varchar fragment a dbase?
//Micke
"Remco Oosten" <[EMAIL PROTECTED]> skrev i meddelandet
003c01c1ded7$72877760$[EMAIL PROTECTED]">news:003c01c1ded7$72877760$[EMAIL PROTECTED]...
> I don't think you can use text(50),
>You can't have NOT NULL assigned to a text field.
So...should it be
maintext text NULL,
or just
maintext text
???
Russell Griechen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Q: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Lisi" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 3:13 A
The problem is that he assigned a length to a TEXT field. You cannot do
that.
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:13 AM
To: [EMAIL PROTECTED]; Lisi
Subject: Re: [PHP-DB] Error creating new table
You can't have NOT
You can't have NOT NULL assigned to a text field.
george
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 10:11 AM
Subject: [PHP-DB] Error creating new table
> I am trying to create the following table using PHPMyAdmin:
>
> CRE
"PHP-DB" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 11:33 AM
Subject: Re: [PHP-DB] Error creating new table
> Worked like a charm, thanks.
>
> How do I avoid varchar if I the size of the text will vary with each
entry?
>
> It's going to be a pretty s
Worked like a charm, thanks.
How do I avoid varchar if I the size of the text will vary with each entry?
It's going to be a pretty small database anyway so I'm not that worried,
but how often do I optimize the table to avoid fragmentation?
-Lisi
At 10:29 AM 4/8/02 +0200, you wrote:
>I don't t
I don't think you can use text(50),
It should be one of the following tinytext, mediumtext or text
Or you should use char(50).
I would try to avoid using varchar() it fragments the database.
Remco
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Mond