469,111 Members | 1,969 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

Datatype Question: Need a longer field length for varchar?

I have a field in my databse that stores comments submitted from a web
form. For some reason the data is being truncated when re-displayed. I
have the settings as follows:

varchar(255) is this the longest field length for varchar?

thanks,
j
Jul 19 '05 #1
2 2368
Jason wrote:
I have a field in my databse that stores comments submitted from a web
form. For some reason the data is being truncated when re-displayed. I
have the settings as follows:

varchar(255) is this the longest field length for varchar?


Pretty much, yes. If you need to save long text messages, how about
using field type "text"?

About char- and varchar-type:
http://www.mysql.com/doc/en/CHAR.html

About text-type:
http://www.mysql.com/doc/en/BLOB.html
Jul 19 '05 #2
Jason wrote:
I have a field in my databse that stores comments submitted from a web
form. For some reason the data is being truncated when re-displayed. I
have the settings as follows:

varchar(255) is this the longest field length for varchar?


Pretty much, yes. If you need to save long text messages, how about
using field type "text"?

About char- and varchar-type:
http://www.mysql.com/doc/en/CHAR.html

About text-type:
http://www.mysql.com/doc/en/BLOB.html
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Kelly Prendergast | last post: by
1 post views Thread by sfh | last post: by
22 posts views Thread by jdokos | last post: by
13 posts views Thread by Madison Kelly | last post: by
1 post views Thread by shsandeep | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.