OT: Insert brackets ( [ , ] ) into mysql table

Cameron Simpson cs at zip.com.au
Tue Nov 7 03:42:22 UTC 2006


On 06Nov2006 01:12, Dylan Semler <dylan.semler at gmail.com> 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 at zip.com.au> DoD#743
http://www.cskk.ezoshosting.com/cs/




More information about the fedora-list mailing list