phpMyAdmin question

programming
1

Guys,

Im using phpMyAdmin to enter records into my database.

I have a problem when entering large amounts of text.

I have an article to add in the database that is no bigger that 2000 characters in length, the field is declared as TEXT. I can INSERT fine, but cannot EDIT or DELETE the record after.

Any ideas?

2

declare it as blob :slight_smile:

3

That might not fix ure bug, however its kinda better using text fields with blob. Personally i have never experianced any problems with text using blob, never used text either. And never used phpMyAdmin for anything. Always done it with php, u might wanna give that a try to see if that helps tho.

Maby its a phpMyAdmin bug.

UPDATE <table> SET message=“ure2000stringthing” WHERE whateverkey=key

4

BLOB is for binary data, like images or files, not for text.