Page 1 of 1

Field type for short strings with variable length

Posted: Tue Jun 10, 2008 5:40 pm
by hayson1991
Is there a field type that can store short strings with variable length? I have strings like "", "_99E", or "883An". I don't know how long or short they will be, but I'm pretty sure it's not going to go over 10 characters.

Sorry, I'm very new to MySQL and also need some help finding documentation.

Thanks in advance. :)

Re: Field type for short strings with variable length

Posted: Tue Jun 10, 2008 6:39 pm
by superdezign
CHAR(10) or VARCHAR(10) will suffice. You shouldn't worry too much about it . Database space is plentiful.