Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Longtext in mySQL allowing only 10 char.

Status
Not open for further replies.

DeZiner

Programmer
Joined
May 17, 2001
Messages
815
Location
US
When initially populating the database field set to long text I can store 1000's of characters. However if I try to update that field I am limited to 10 characters. I see only the first 10 letters after updating when I query. No errors are happening. DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic
 
are you using a form to update this db? if so check that the form field does not have a maximum length.
 
Did you try to issue the update "query" from the SQL command tool that comes with mySQL? Did it work? In other words, is the problem with mySQL?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top