On 06Nov2006 01:12, Dylan Semler <dylan.semler@xxxxxxxxx> wrote: | You can't fit a 5 character string into a 1 character column! | | Ah, I suppose I should have caught that. It may be obvious that I'm new to | mysql. I created the columns with simply CHAR and didn't specify a character | length, hoping it would allow unlimited number of characters. I see now that | it did the opposite. Thanks for the help. You want something like VARCHAR. See the MySQL data types manual section: http://dev.mysql.com/doc/refman/4.1/en/char.html Cheers, -- Cameron Simpson <cs@xxxxxxxxxx> DoD#743 http://www.cskk.ezoshosting.com/cs/
