# phpMyAdmin question

**URL:** <https://forum.kirupa.com/t/phpmyadmin-question/63821>\
**Category:** programming\
**Created:** [September 10, 2004, 8:43am UTC](https://forum.kirupa.com/t/phpmyadmin-question/63821 "2004-09-10T08:43:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![w\_digital](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@w\_digital](https://forum.kirupa.com/u/w_digital)\
**Post date:** [September 10, 2004, 8:43am UTC](https://forum.kirupa.com/t/phpmyadmin-question/63821/1 "2004-09-10T08:43:37Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 10, 2004, 8:47am UTC](https://forum.kirupa.com/t/phpmyadmin-question/63821/2 "2004-09-10T08:47:41Z")

</div>

declare it as blob 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 10, 2004, 8:50am UTC](https://forum.kirupa.com/t/phpmyadmin-question/63821/3 "2004-09-10T08:50:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 10, 2004, 5:44pm UTC](https://forum.kirupa.com/t/phpmyadmin-question/63821/4 "2004-09-10T17:44:59Z")

</div>

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