>>>>> "Kyle" == Kyle Moore <[EMAIL PROTECTED]> writes:
Kyle> I have two questions about mysql. I have looked around but haven't found
Kyle> any answers.
Kyle> The first question is....Does mySQL allow you to set security based on
Kyle> groups rather than just users?
No. But as the MySQL permission system is independent of the operating
system, many users can easily share an account.
Kyle> My second question is about datatypes. Is BLOB/TEXT variable length? Can I
Kyle> set a maximum length of less than 65535 characters? If I have a BLOB/TEXT
Kyle> field and type in 623 characters does it still store 65535 characters (or
Kyle> whatever the max length is if I can change that)? I'm wondering about this
Kyle> because if it stores every record as 65,535 bytes our database would get
Kyle> HUGE quickly.
For BLOB/TEXT or VARCHAR types, MySQL only store what you enter (+ a
small overhead to store the length information)
Regards,
Monty
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
