>>>>> "JB" == Jack Barnett <jbarnett@stripped> writes:
JB> Pretty new to MySQL and DBs in general, I need to use a boolean data type
JB> (has 2 possiable values true or false || 0 and 1), but didn't see any ways
JB> to do this, I though about just using a CHAR(1), but was wondering if there
JB> was a better way to do this that might save some memory.
Well, in a normal program in most languages you'd use an enumerated
type to represent your two values. Guess what... mysql has them as
JB> Also is there a "Password" data type that has the string value
JB> encrypted, or is it up to the user to encrypt it before it is
JB> insert into the database?
Mysql has encrypting functions, but most likely you'd want to encrypt
your data before sending it down the wire to the database server.
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@stripped Rockville, MD +1-301-545-6996
GPG & MIME spoken here http://www.khera.org/~vivek/