471,092 Members | 1,525 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Working with the text datatype in MySQL

Hi All,

I am managing a small database and some of the tables
need to be strings of an average length of about 2,000
characters.

I decided to use the text datatype to store this
information knowing that the upper limit is about
65,000 characters.

However, the system crashes when the user tries to
enter about 2,000 characters. I checked the
max_allowed_package and net_buffer_size variables and
they are both set to 1MB.

Could you please advice me on what to look for or what
to change in order for the system to work as it is
supposed to be working?

I look forward to hearing from you soon.

Thanks in advance.

George

__________________________________________________ ______________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1654

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Lekeas GK | last post: by
reply views Thread by Lekeas GK | last post: by
reply views Thread by Mike Hillyer | last post: by
2 posts views Thread by Joel | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.