| Bug #49328 | Can't edit TEXT fields | ||
|---|---|---|---|
| Submitted: | 2 Dec 2009 6:57 | Modified: | 2 Dec 2009 11:48 |
| Reporter: | Edward Rudd | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.2.8 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
this is a duplicate of Bug #48982
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.5-u2-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
© 2025, Oracle Corporation and/or its affiliates
Description: I have a table with a column of type TEXT NOT NULL and whenever I select content from the table or try to "EDIT" the table it does not show the contents of the field.. it only shows a "0". Also if I try editing the content in "EDIT" mode (or adding a new entry) it will not let me enter anything but a number (and the embedded edit control is a number "spinner"). if I use raw SQL to "INSERT" or "UPDATE" it of course works fine. This occurs on both Mac OS X and Linux How to repeat: CREATE TABLE myTable ( ID int not null auto_increment PRIMARY KEY, myText TEXT ); INSERT INTO myTable (myText) VALUES ('Test'); Then run EDIT `myTable` the result view will list ID myText 1 0 But if I do this SELECT ID, CAST(myText AS CHAR(200)) FROM myTable I can actually view the content.