Page 1 of 1

Studio debug error "Data too long for Column in_watch_value

Posted: Wed 06 Apr 2011 14:43
by abelekj
How can I execute Debug when I have a long string. I have defined a VARCHAR(4000) variable in my code to match the definition in the database. When I execute a FETCH (in debug mode) I get the error "Data too long for column 'in_watch_value' at row 72. This occurs at the command where I execute a FETCH against the table that contains the long string. Should I be using a different variable type of is my dBForge configuration incorrect. The code seems to work when not in DEBUG mode but I need to look at the logic more closely. I DO NOT have any watchpoints set so I do not know how to proceed. I have tried typing the variable as VARCHAR, MEDIUMTEXT, LONGTEXT and BLOB with the same error. Any help would be appreciated

Posted: Thu 07 Apr 2011 07:02
by Alexz
Could you specify the full version of dbForge Studio for MySQL? You can learn it from the About dialog (the Help->About menu).

Posted: Thu 07 Apr 2011 15:11
by abelekj
I am running Standard Edition dbForge Studio for MySQL version 4.50.300

Posted: Fri 08 Apr 2011 07:19
by .jp
abelekj wrote:I am running Standard Edition dbForge Studio for MySQL version 4.50.300
This build is very old. Please download the latest build (4.50.348) and check whether the problem persists.

Posted: Fri 08 Apr 2011 14:42
by abelekj
Upgrading did resolve the problem. Thanks.