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