phpmyadmin：如果数据最初存储为数组，则无法更改文本的值

I've made a table with the following fields:

`id` type:INT,
`id_list`type:TEXT,
`name`type:VARCHAR(255).

id is my primary key.

From phpmyadmin 3.4.11.1deb2, I inserted a row:

(`null`, `'["1","2","3","4"]'`, `'TEST'`)

and it successfully saves to the table.

However, when I try to update the id_list field, instead of a text-field containing ["1","2","3","4"], I see a drop-down-list with each row equivalent to the text array that I stored.

Is this by design or a bug in the way that phpmyadmin is renders the resulting text?

I had to use a different table as an example, but notice the drop-down-list instead of a text-field.

You probably have some relations between tables through these fields, as @Wrikken said in comments to your question. I've used a pretty similar table structure, and also added one more table to reproduce the assumption I'm talking about:

-- First table, similar to problem table

CREATE TABLE bars ( id int(11), list text, bar varchar(255), PRIMARY KEY (id) );

INSERT INTO bars (id, list, bar) VALUES (1, '["1","2","3","4"]', 'TEST');

-- Second table, to reproduce the assumtion

CREATE TABLE foos ( id int(11), foo varchar(255), PRIMARY KEY (id) );

INSERT INTO foos (id, foo) VALUES (1, 'foo1'), (2, 'foo2'), (3, 'foo3'), (4, 'foo4'), (5, 'foo5'), (6, 'foo6');

From scratch everything works fine as expected, i can edit TEXT field as text:

To reproduce 'dropdown' effect I've opened a problem bars table (with TEXT field) relations:

and have added a reference to foos, a table with possible ids, that are stored in list TEXT field as array:

Now when editing a record i have a dropdown instead of textarea for TEXT list field

So, try to check whether you have your TEXT field involved in any relations

sorry, no rep to comment yet, so giving a complete answer that may not be a solution at all